ObjectProperty returning Null

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » ObjectProperty returning Null

ObjectProperty returning Null

Rate Topic

Display Mode

Topic Options

Author

Message

Shark Energy

Posted Friday, April 04, 2008 4:42 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 22, 2013 9:32 AM
Points: 547, Visits: 995

Checking to see if a Trigger is enabled on a table or not.

I'm running the objectproperty function returning for the system id of the table and the property ExecIsTriggerDisabled. This is returning NULL. I know the id is correct, and I know the property is correct. It returns 1 for "HasInsertTrigger".

According to BOL NULL means the object doesn't exist (false) or the property doesn't exist (false). It also says you might not have permissions to view the property. I'm sa so I have.

Any ideas why this is returning NULL?

Oh and I realise I could just enable the trigger to make sure it is....but the table is replicated so it won't let me without dropping repl first. No thanks.

Cheers

Post #479809

SQLZ

Posted Friday, April 04, 2008 4:47 AM

SSC Eights!

Group: General Forum Members
Last Login: Thursday, May 02, 2013 5:38 AM
Points: 870, Visits: 858

You're supposed to use the object id of the trigger, not the table.

select objectproperty(object_id('name of trigger'), 'ExecIsTriggerDisabled')

Karl
source control for SQL Server

Post #479811

Shark Energy

Posted Friday, April 04, 2008 5:01 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 22, 2013 9:32 AM
Points: 547, Visits: 995

Cheers! haha. Works now.

Post #479820

« Prev Topic | Next Topic »

Permissions