Tim Karki

  • Home
  • Photography

  Colorado

Categories

  • Computer Stuff
  • General
  • JQuery
  • Microsoft

Tags

.NET Access Modifiers ADO.NET Button attribute C# Check temporary space DOS entity framework Explain plan Grid to Excel horizontal listing IIS internal Javascript Jquery JSON LinkedIn linked server Linux Membership Framework Microsoft MSSQL openSSL Oracle pfx PHP PLSQL protected protected internal Regex results server shell scripting Smooth Gallery Source Safe sql SSL Stored Procedure Total file size triggers Unix VB.NET VSS Web Server Web Services

Archives

  • January 2014
  • May 2013
  • July 2012
  • May 2012
  • June 2011
  • November 2010
  • October 2010
  • December 2009
  • November 2009
  • March 2009

Tag / triggers

June 1, 2011 by Tim Karki

Show all triggers in a database in MSSQL

  • Computer Stuff, Microsoft
  • LinkedIn, Microsoft, MSSQL, server, sql, triggers
  • Leave a comment
SELECT object_name(id), object_name(deltrig),
object_name(instrig), object_name(updtrig)
FROM sysobjects
WHERE xtype ='U'
AND
(deltrig > 0 OR instrig > 0 OR updtrig > 0)
FacebookTwitterGoogle+Share
Proudly powered by WordPress | Theme: editor by Array