newbee 
Author Message
 newbee
I want to find the name of all the table on which triggers
are disabled.
I mean how can I make a query on system tables to get
this. any idea?

TIA



Sun, 04 Jun 2006 23:01:55 GMT
 newbee

select  distinct(object_name(parent_obj)) as tableName

from  sysobjects
where  xtype = 'TR'
and OBJECTPROPERTY(id, 'ExecIsTriggerDisabled') = 1

--
----------------------------------------------------------------------------
-----------

Compass Technology Management

Pro SQL Server 2000 Database Design
http://www.apress.com/book/bookDisplay.html?bID=266

Note: Please reply to the newsgroups only unless you are
interested in consulting services.  All other replies will be ignored :)


Quote:
> I want to find the name of all the table on which triggers
> are disabled.
> I mean how can I make a query on system tables to get
> this. any idea?

> TIA



Sun, 04 Jun 2006 23:40:43 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. newbee seeks upgrade help

2. sql 7 newbee

3. Newbee: Trigger problem

4. Newbee Quetion :-)

5. Newbee: How to connect through perl

6. newbee crystal report question

7. Newbee Question

8. dynamic sql - newbee question

9. SP newbee tips?

10. newbee sp_spaceused problem

11. Replication question (Newbee)

12. Newbee SQL Server Question


 
Powered by phpBB® Forum Software