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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Triggers

Status
Not open for further replies.
AshleyRickards

AshleyRickards

MIS
Jun 29, 2001
195
US
Isn't it possible to have multiple triggers of the same type? In this case INSERT, UPDATE but with different rules for different fields?

TIA

Ashley L Rickards
SQL DBA
 
Sort by date Sort by votes
Yes on SQL 2000 it is. See create trigger in BOL.

Denny

--Anything is possible. All it takes is a little research. (Me)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Farrukh hameed
  • Locked
  • Helpful tip
Single Connection string control multiple database connection on case condtion
Replies
1
Views
227
fredericofonseca
fredericofonseca
TheBugSlayer
  • Locked
  • Question
Backu and restore of multiple filegroups
Replies
2
Views
127
TheBugSlayer
TheBugSlayer
cajuntank
  • Locked
  • Question
Multiple instances on a SQL cluster?
Replies
2
Views
60
cajuntank
cajuntank
cajuntank
  • Locked
  • Question
Multiple instances or multiple VMs?
Replies
1
Views
52
fredericofonseca
fredericofonseca
MikeM2468
  • Locked
  • Question
Transaction log backups to multiple destinations
Replies
1
Views
47
SQLBill
SQLBill

Part and Inventory Search

Sponsor

Back
Top