Results 1 to 3 of 3

Thread: Trigger on System Table...

  1. #1
    Join Date
    Mar 2005
    Posts
    2

    Question Trigger on System Table...

    Hi,

    I want to create a trigger on sysfiles. I had logged in as sa account but able to create it... I am getting the below error...

    Server: Msg 229, Level 14, State 5, Procedure TAU_Sysfiles_WSCLog_Reminder, Line 65535
    CREATE TRIGGER permission denied on object 'sysfiles', database 'WorldScope_Dev', owner 'dbo'.

    Can any body please help me how to go ahead creating trigger in the system tables...

    Thanks in Advance...

    -Mohit.

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    No. You cant.

    Create another table similar to sysfiles and compare the sysfiles and the new table every 1 minute for any changes.

  3. #3
    Join Date
    Mar 2005
    Posts
    2
    Thanks Mak... I think better option is to create a job and schedule it...

    Thanks one more time for iving the alternate soultion...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •