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)
 Scripts for change in database tables and Sprocs

Author  Topic 

anarayanamoorthy
Starting Member

15 Posts

Posted - 2011-08-15 : 03:21:30
Hi,

If a user is updating a column name or adding and deleting a stored procedure in the database, can I come to know which table or which procedure the user has changed. Do we have any scripts to check it.

Cheers,
Narayanamoorthy A

lionofdezert
Aged Yak Warrior

885 Posts

Posted - 2011-08-15 : 05:03:04
Create a DDL trigger
http://connectsql.blogspot.com/2009/07/create-ddl-changes-log.html

--------------------------
http://connectsql.com/
Go to Top of Page
   

- Advertisement -