same temporary table and cursor names running on different DBs and same server

same temporary table and cursor names running on different DBs and same server

 

  

Hi Guys,

I have the same set of stored procedure running on different DBs on the same server. This stored procedure is using temp tables and cursors.
The stored procedure will be scheduled to run everyday, synchronously.

Would this cause data and stored procedure inconsistencies considering it's declaring the same set of temp tables and cursors?

Thanks in advance.
Ray





MS Sql Server LazyDBA home page