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)
 who made change to table structure?

Author  Topic 

hai
Yak Posting Veteran

84 Posts

Posted - 2009-01-30 : 18:04:59
Is there any way to track who modified the table structure...the table was column was change form int to binary....

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-30 : 18:13:47
Yes. Look at Schema Change Report in Standard Reports.
Go to Top of Page

hai
Yak Posting Veteran

84 Posts

Posted - 2009-01-30 : 18:29:30
Thanks SoDeep...

I just realized this is an sql2000 servers...anything for 2000?

thanks again
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-30 : 21:46:41
I don't think you can do without third-party tools as far as I know.
Go to Top of Page
   

- Advertisement -