RG_WhatsChanged_v4 XML parameter for databases

DOCDOC Posts: 2 New member
in SQL Source Control
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:
· Share on Twitter

Best Answer

  • Mike UMike U Posts: 316 Gold 1
    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
    · Share on Twitter
Sign In or Register to comment.