determine which account modified stored procedure(sql 2008 EE)

  • 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.

  • 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.

  • 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