Hi, I have an SQL Server 2005 database, whose tables were audited by triggers. I wanna know if by SQL Profiler I can audit the modification of those triggers as well as the enable an disable activity.
Many thanks !
View Complete Post
Memory usage can have a direct impact on how fast an application executes and thus is important to optimize. In this article we discuss the basics of memory optimization for .NET programs.
Subramanian Ramaswamy and Vance Morrison
MSDN Magazine June 2009
Learn how to enable an auditing solution for Windows SharePoint Services (WSS) 3.0 with customized control pages in Microsoft Office SharePoint Server (MOSS) 2007.
MSDN Magazine September 2008
What to do when you need to disable triggers and constraints to perform data synchronization and other tasks with an offline database.
MSDN Magazine April 2007
MSDN Magazine January 2004
MSDN Magazine December 2003
What is the reason for this restriction for Output clause?
If the OUTPUT clause is specified without also specifying the INTO keyword, the target of the DML operation cannot have any enabled trigger defined on it for the given DML action. For example, if the OUTPUT clause is defined in an UPDATE statement, the target
table cannot have any enabled UPDATE triggers.