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
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Temp Tables Question

Author  Topic 

Da_Retina
Posting Yak Master

109 Posts

Posted - 2001-09-15 : 05:27:47
Thanks in Advance for any help.
My case is that I am creating temp tables in a trigger to hold "Deleted" and "Inserted" contents, so that I can pass them to stored procedures. The problem is that my trigger alters other tables that will fire a trigger whose code is similar to the first one.So basically I am creating two tables name #TempDeleted or two tables called #TempInserted for the same session..will this conflict?..and what is the work around?..
thanks again!

   

- Advertisement -