Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why temp table Inserted is not visible outside trigger?
Message
From
07/09/2009 01:11:25
Kevin Goff
Pennsylvania, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Other
Title:
Re: Why temp table Inserted is not visible outside trigger?
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01152798
Message ID:
01422918
Views:
47
I will have to read about CDC - thanks.

http://www.mssqltips.com/tip.asp?tip=1474



One thing to remember about CDC is that it doesn't eliminate the need for triggers (for change tracking) - but it can greatly reduce the code you'd otherwise put in a trigger.
"Run, you clever boy....and remember"
https://www.youtube.com/watch?v=8U4Y2Uv8ArM

"My survival...my living proof"
https://plus.google.com/photos/117162300364810952313/albums/5876836271056272097/5876836294121419858?banner=pwa&pid=5876836294121419858&oid=117162300364810952313
Previous
Reply
Map
View

Click here to load this message in the networking platform