RG_WhatsChanged_v4 XML parameter for databases

I am looking to use the dbo.RG_WhatsChanged_v4 stored procedure manually to check the permissions I just added for my users. One of the parameters is to use XML. Does anyone have the schema for it to use?
Tagged:

Best Answer

  • Mike UMike U Posts: 315 Gold 1
    Accepted Answer
    The XML parameter is a list of the database names that you want to check for changes. It's in the following form:
    <stringarray>
      <element>
        <seqno>1</seqno>
        <item>{first-database-name-to-check}</item>
      </element>
      <element>
        <seqno>2</seqno>
        <item>{second-database-name-to-check}</item>
      </element>
      ...
    </stringarray>
    

    You should replace {first-database-name-to-check} etc. with the actual database names in your system, and for each new <element> you add to the list you should increment the <seqno> value.
    Development Lead
    Redgate Software
Sign In or Register to comment.