Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Schema Changes History tables

Author  Topic 

learntsql

524 Posts

Posted - 2009-11-18 : 00:12:08
How to know the tables used by
The SQL Report "Schema Changes History"
In my Database there is diff. between sp deffenition from TestDB to Production db.
How can i trace when and who changed that where everybody logsin as "sa" account.
Any other ways.

svicky9
Posting Yak Master

232 Posts

Posted - 2009-11-18 : 08:28:13
You can use the DDL Triggers

http://msdn.microsoft.com/en-us/library/ms186406.aspx


http://www.sqlserver007.com
Go to Top of Page

Itamar
Starting Member

19 Posts

Posted - 2009-11-19 : 07:14:49
Hi,
You can use a tool for data and schema version control, called: Randolph

-----

Nob Hill Software - Tools for Database people
Go to Top of Page
   

- Advertisement -