Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Trigger question
Message
From
22/01/2001 19:56:15
 
 
To
22/01/2001 12:34:37
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00466553
Message ID:
00467068
Views:
15
>>Main problem here is the SP you call from the trigger won't have access to the inserted/deleted tables.
>
>yeah - and that's a show-stopper in my case - thanks!

You may try something like...

select from inserted into #inserted
select from deleted into #deleted

The, you should be able to access those temp tables in a SP you call.

BOb
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform