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.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Triggers

Author  Topic 

shovater
Starting Member

1 Post

Posted - 2011-06-23 : 10:25:46
I have a trigger which updates four different tables when fired. In SQL Server Management Studio the Trigger fires and updates all tables. When the trigger table is updated by other means only one table is updated. Anyone have a clue what's happening?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-23 : 12:26:14
That doesn't sound right. Show us the code (trigger code, DDL for the tables, sample rows, and a sample update statement).

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -