June 18, 2008 at 2:23 am
Hi,
we are using window's authentication in my server. I want to know, who (hostname or machine id) is updated and compiled any sp's recently . Plz help me to get that list .
Thanks.
June 18, 2008 at 2:34 am
bkrishnasamy (6/18/2008)
Hi,we are using window's authentication in my server. I want to know, who (hostname or machine id) is updated and compiled any sp's recently . Plz help me to get that list .
Thanks.
I'm affraid you cannot get this information without setting up some ddl triggers or a trace in advance. You can look at when a schema object has been modified the last time (sys.objects -> modify date), but who made the change is not stored.
Regards,
Andras
June 18, 2008 at 3:19 am
Could you explain ,how to setting the trace in advance or
tell me about the ddl trigger.
June 18, 2008 at 3:26 am
Select profiler and you can run new trace from there...
June 18, 2008 at 3:34 am
bkrishnasamy (6/18/2008)
Could you explain ,how to setting the trace in advance ortell me about the ddl trigger.
Both of these are largish topics, so I'd suggest you look at Books Online, SQL Server's documentation. For DDL triggers see http://technet.microsoft.com/en-us/library/ms186406.aspx
For traces and the profiler http://msdn.microsoft.com/en-us/library/ms187929.aspx
Regards,
Andras
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply