Skip to main content
Database Administrators

Return to Question

Tweeted twitter.com/#!/StackDBAs/status/367708005489729536
added 6 characters in body; edited title
Source Link
marc_s
marc_s
  • 9k
  • 6
  • 45
  • 52

Tracking changes in stored procedures within a databsedatabase

Could you please help me out here. I

I have mutliplemultiple databases and each of the databases have the same tables and stored procedures. I

I want to be able to compare the stored procedures and see if there were any changes made to one stored procedure in one database, that has not been replicated across the remaining databases. I

I also want to be able to fine out if there were changes made to any tables (structure or new tables added in one and not in the rest). I do not need to know if the data within a table has been updated or if one table has more rows than the other.

Tracking changes in stored procedures within a databse

Could you please help me out here. I have mutliple databases and each of the databases have the same tables and stored procedures. I want to be able to compare the stored procedures and see if there were any changes made to one stored procedure in one database, that has not been replicated across the remaining databases. I also want to be able to fine out if there were changes made to any tables (structure or new tables added in one and not in the rest). I do not need to know if the data within a table has been updated or if one table has more rows than the other.

Tracking changes in stored procedures within a database

Could you please help me out here.

I have multiple databases and each of the databases have the same tables and stored procedures.

I want to be able to compare the stored procedures and see if there were any changes made to one stored procedure in one database, that has not been replicated across the remaining databases.

I also want to be able to fine out if there were changes made to any tables (structure or new tables added in one and not in the rest). I do not need to know if the data within a table has been updated or if one table has more rows than the other.

Source Link
Amith
Amith
  • 21
  • 1
  • 2

Tracking changes in stored procedures within a databse

Could you please help me out here. I have mutliple databases and each of the databases have the same tables and stored procedures. I want to be able to compare the stored procedures and see if there were any changes made to one stored procedure in one database, that has not been replicated across the remaining databases. I also want to be able to fine out if there were changes made to any tables (structure or new tables added in one and not in the rest). I do not need to know if the data within a table has been updated or if one table has more rows than the other.