Link to home
Start Free TrialLog in
Avatar of dotnetpro
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 ?
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

you can see when was the last alter in information_schema.routines

in order to see who did it you will need some tool that can parse the transaction log files
Avatar of chapmandew
Log Explorer from Lumigent will do the trick for you to see who altered it.
Avatar of dotnetpro
dotnetpro

ASKER

I ran this script

select * from information_schema.routines 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!
ASKER CERTIFIED SOLUTION
Avatar of chapmandew
chapmandew
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial