-
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.
-
No. You cant.
Create another table similar to sysfiles and compare the sysfiles and the new table every 1 minute for any changes.
-
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
-
Forum Rules
|
|