Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I create a trigger refrencing a DBC table?

Status
Not open for further replies.

CVENOM

Programmer
May 6, 2003
7
US
I'm trying to create a trigger that that will reference a table in DBC, and insert rows into a table outside of DBC. The problem I'm running into is an error saying "Failure 3524 The user does not have CREATE TRIGGER WITH GRANT OPTION access to database DBC." I'm not creating the trigger in DBC, I'm creating it in a seperate DB. I can't grant the required permissions to any user in the system (including DBC). Is there any way to create a trigger that references a DBC table? Any help would be appreciated.
 
You can't create triggers on dbc tables.

Even if you bypassed accessrights and granted the appropriate rights to create it, the trigger will probably not fire, because system tables are sometimes not maintained by SQL.
And if they are, maybe you'll crash the system...

Dieter
 
Thanks, that's kind of what I had figured....
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top