General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
>>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only