Trigger on a System table - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Trigger on a System table

Author

Topic

Shastryv
Posting Yak Master

145 Posts

Posted - 2005-12-19 : 14:11:49

Folks, My question is more on MS policies than technical. I am planning on writing a trigger on system table sysconfigures, to notify the DBA's if there is any change in sys configure options. Does it become an issue with MS Supporting the system in case if you need any help from MS down the line ?

Appreciate your response

Thanks

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-12-19 : 14:39:12

it won't work.

-ec

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-12-19 : 14:41:44

for clarification, you might be able to create a trigger on certain tables but they aren't guaranteed to fire.

here is some more info http://www.sql-server-performance.com/q&a129.asp

-ec

Shastryv
Posting Yak Master

145 Posts

Posted - 2005-12-19 : 14:46:13

yeah i have seen that article but i am looking for more on MS Supportability issue. Thanks for the info.

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2005-12-19 : 14:47:01

quote:
Originally posted by Shastryv

yeah i have seen that article but i am looking for more on MS Supportability issue. Thanks for the info.

well, you will be completely unsuppported.

-ec

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-12-19 : 15:23:30

The system won't even let you create a trigger on sysconfigures. So you don't even need to worry about it not being supported by MS as it won't let you do it anyway.

Tara Kizer
aka tduggan

Shastryv
Posting Yak Master

145 Posts

Posted - 2005-12-19 : 16:07:21

Tara, you can create a trigger on sysconfigures without a problem, however you won't able to create on sysobjects.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-12-19 : 16:22:08

Ummm, it didn't work for me:


use master 
go 
create trigger test on dbo.sysconfigures 
for insert, update, delete 
as 
select 'Test'
go

quote:

Server: Msg 229, Level 14, State 5, Procedure test, Line 3
CREATE TRIGGER permission denied on object 'sysconfigures', database 'master', owner 'dbo'.

Tara Kizer
aka tduggan

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources