Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

creating trigger on master db tables

Status
Not open for further replies.
walshij

walshij

Programmer
Feb 7, 2003
3
GB
is it possible to create a trigger against the Master tables ie if the sysprocess table changes I want to insert a reocrd into another table. I seem to haveaccess problems when I try, even when logged on as sa.

Regards
Ian
 
Sort by date Sort by votes
You cannot create triggers on system tables and the tables in the master db are system tables. Why? because you could break something so Microsoft doesn't let you even try.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SashaBuilder3
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
445
SashaBuilder3
SashaBuilder3
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
292
Chris Miller
Chris Miller
peac3
  • Locked
  • Question
split one row into multiple rows... help pls 2
Replies
12
Views
734
Chris Miller
Chris Miller
Niki_S
  • Locked
  • Question
Join SQL tables in foxpro
Replies
1
Views
111
pjw001
pjw001
Auguy
  • Locked
  • Question
Move SQL DB to the Cloud and Access it From a .Net Program
Replies
0
Views
92
Auguy
Auguy

Part and Inventory Search

Sponsor

Back
Top