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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-10-22 : 23:26:06
|
| Shane writes "Does SQL 7.0 support triggers on system tables? I get an error stating that I do not have permissions to create a trigger on a system table even though I am a dbo. If this is not supported, is there another way to log system table modifications? I need the functionality to record when anyone modifies any data in any table in the database. I would like to do this by monitoring a few system tables and not putting a trigger in every table in the database. Any recommendations are appreciated." |
|
|
|
|
|
Triggers On System Tables