CODEWITHSUNDEEP
sqlsql-serversql-server-2008
maxisam
maxisam

Reputation: 22715

Schema Changes History - what was ALTERed about the object?

Is there anyway to figure out what was altered ?

I have pull out the report with the transactionID, but I can't figure out what change was made exactly.

The system is SQL Server 2008.

Upvotes: 0

Views: 994

Answers (2)

David Atkinson
David Atkinson

Reputation: 5899

If you're looking for integrated source control in SSMS, might I suggest SQL Source Control, which is a tool that I product manage here at Red Gate? I'd be interested to get your thoughts on whether this would meet your needs.

http://www.red-gate.com/products/sql-development/sql-source-control/

Upvotes: 0

gbn
gbn

Reputation: 432271

You'll have to restore an earlier backup and compare unless you track these changes:

  • in source control
  • managed release scripts
  • DDL triggers
  • have extended events switched on

Even then you won't get the transaction id that was the ALTER in all techniques

Upvotes: 2

Related Questions