sql server 2005 - last modified

[ultim]

Hi,

I have made some changes to my local database and stupidly i didnt keep track of what i changed!

Now i need to update the changes to the live database.

In sql server is there a way to find what was changed by date?

 

[Beepcake]

Nope. You'll need a database compare tool like sqlcompare, sql delta or Visual Studio Database edition

 

[akakjs]

Try the change tracking system views msdn information here.

You can also access a report from Sql Management Studio (Right-click the database->reports, schema changes)/.

akakjs