Tuesday, February 14, 2012

Database Trigger in MSSQL

How can i create database level triggers in MS SQL? i m not talking
about table trigger or view trigger.

Khurram.What do u really want to capture?|||Khurram (khurramanis@.gmail.com) writes:
> How can i create database level triggers in MS SQL? i m not talking
> about table trigger or view trigger.

In SQL 2000 you cannot create trigger on database level. In SQL 2005,
currently in beta, you can.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp