Post reply

Triggers on system tables

  • November 30, 2004 at 5:49 am

    #182962

    Probably a 'No', but I was wondering if it was possible in any way to add triggers to system tables. i.e. a trigger on sysfiles that emails me if someone sets maxsize to unrestricted.

    I've tried "sp_configure 'allow updates',1", but am still getting permission denied.

    Cheers.

  • November 30, 2004 at 5:58 am

    #531839

    Definitely a 'No'.

    Technically you can create triggers on certain tables in MSDB, but that's all. Do a search here. This has been discussed several times before.

    Maybe you should tighten your permissions. No everyone should be able to set maxsize.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • November 30, 2004 at 7:00 am

    #531851

    Thanks.

    Unfortunately the user needs to be dbo of certain databases, I'll just set up some nightly integrity checks instead

  • November 30, 2004 at 9:06 am

    #531880

    It's highly frowned upon and could cause problems. In SQL Server 7, triggers on system tables were not guarenteed to fire.

    I'd setup a job that runs every hour to look for this.

  • November 30, 2004 at 9:45 am

    #531898

    Yes it is possible, just don't do it.

    http://www.sqlservercentral.com/columnists/rmarda/letsblockthedba.asp

    Change you SA password and see who complains, then shoot them.

    LinkedIn Profile

  • November 30, 2004 at 9:56 am

    #531903

    Thanks David,

    that is, indeed, nasty! Might just have a little try on a desktop server and see what breaks!

     

     

  • November 30, 2004 at 1:33 pm

    #531953

    Well, even if it doesn't break a thing, at best you're running an unsupported system. I wouldn't call Microsoft PSS with an issue with such a system. Not everything that can be done, should be done. 

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 1, 2004 at 4:57 am

    #532029

    lmao

    Never thought of doing that one!!

Viewing 8 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply