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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Discovering when a trigger was deleted

Status
Not open for further replies.

alebox20

Programmer
Oct 19, 2004
72
BR
I had 3 triggers in a table (SQL Server 2000). It is deleted, but I don't know, who/when it was.

Is there a way to know it?

thanks

 
no there is not any way to tell when it was dropped.
In SQL 2005 you can create DDL triggers to audit those types of actions.

- Paul
- If at first you don't succeed, find out if the loser gets anything.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top