December 18, 2009 at 12:35 pm
Trying to find out which account modified a stored procedure.
If I run the schema change report, the report does not go back far enough (days) to capture the specific proc.
Is there an easy select statement to run to find the account?
Thanks in advance.
December 18, 2009 at 2:49 pm
Unfortunately I don't know of anywhere that SQL Server collects that information. For future reference the Schema Changes Report gets its data from the Default Trace. You can setup a job that can archive the default trace files and/or load the data into a table so you can retain the data longer. You could just load schema changes from the Default Trace into a table on a daily basis as well.
Your other option is a DDL trigger that logs schema changes to a table.
I know neither of these helps now, but I figured you might want to have options for the future.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
December 23, 2009 at 6:29 pm
This won't give you the user, but some info may be stored in sysobjects.dbo.crdate
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply