Trigger a trigger event when a new trigger is created
Trigger a trigger event when a new trigger is created, for a moment I was muffled with number of times you need to mention to call the subject. So looking at the need you will have to ask whether it is possible or not.
Coming to the subject, yes it is possible when you are using SQL Server version 2005, as you can take help of DDL triggers. From SQL Server 2005 Service pack2 you can have such funcationaility of DDL based auditing that is equivalen to install Service broker for any sort of alert notification on SQL Server.
So if you think about auditing there are various things you need to consider, such as trace events to be capture, audit_login with successful & failed process, deadlock notifications and blocking reports. As explain you can take help of Notification Services (also refer to Article on building effective NS applications) using with SQL Server.
So with the SQL Server 2005 version features along with Service pack2, you can use a DDL trigger to create one for CREATE TRIGGER action, this will fire the DDL trigger. The MSDN link below will give more information on their usage:
**__________________________________**
SQL Server MVP, Sr. DBA & industry expert.
-
Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it. It is also a power and you will gain by sharing it.