anarayanamoorthy
Old Hand
Points: 313
More actions
August 15, 2011 at 1:20 am
#255511
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.
Regards,
NM
Florian Reischl
SSC-Dedicated
Points: 37301
August 15, 2011 at 2:59 am
#1368477
Hi
A database level DDL trigger should help you to create a logging for schema modifications:
Designing DDL Triggers
Greets
Flo
Grant Fritchey
SSC Guru
Points: 398909
August 15, 2011 at 5:39 am
#1368524
Some DDL operations are also available in the default trace, but not all.
Otherwise, you need to set up a system for monitoring this ahead of time.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"- Theodore Roosevelt
Author of:SQL Server Execution PlansSQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply