Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

dts package

Status
Not open for further replies.
Jul 30, 2007
42
US
Does anybody know how to track who delete the DTS pkg from sql server?? Or who has logged on the the server during certain period of time?? thanks
 
In both cases you would have to run a security audit trace with SQL profiler. Don't do it from your production server. Run the trace from a client PC because profiler is a resource pig.



- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
where do i see the information after the trace has been ran??
 
you have to select the security criteria before you start the trace. By default that information is not in the trace.

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
It's difficult if not impossible to figure it out after the fact. You might try:

1. look at the security logs (Computer Management>System Tools>Event Viewer>Security) and see who was logged in during the timeframe the package was deleted.

2. get a 'log reader' program and see if you can read the transaction log for the timeframe.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top