\\Dev's Place
\Debug \Build \Deploy \Defects \Issues \Tips \Tricks ...
Jul 1, 2008
Get all the triggers for a Database
To get all the triggers list and their scripts run the script below. View the result in file view mode.
SELECT [text]
FROM sysobjects o
JOIN syscomments c ON o.id = c.id
WHERE xtype = 'TR'
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
SQL - Difference between CAST,CONVERT and PARSE
TODO---
Clustered Index vs Non Clustered Index
Clustered Index | Non Clustered Index Indexing is used to get fast retrival of data. The indexing which is done on physical storage is known...
Haj committee India | Haj 2008 Lucknow
All about Haj, please visit http://www.hajcommittee.com This year UP haj pilgrims will be decided on lottery draw due to more responces of l...
Get all the triggers for a Database
To get all the triggers list and their scripts run the script below. View the result in file view mode. SELECT [text] FROM sysobjects o ...
No comments:
Post a Comment