dotnetpro
asked on
SQL execution log
Experts is there a way to find out when and by who the last ALTER statement to alter a procedure was run on against a SQL 2000 database ?
Log Explorer from Lumigent will do the trick for you to see who altered it.
ASKER
I ran this script
select * from information_schema.routine s where routine_name ='usp_Get_pal_On_Trail'
and it returned a record with creation and modification date from march 08 where as i altered this procedure last evening. Strange!
select * from information_schema.routine
and it returned a record with creation and modification date from march 08 where as i altered this procedure last evening. Strange!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
in order to see who did it you will need some tool that can parse the transaction log files