Hi,

Any thoughts on my concern below?

Thanks,
Ray

-----Original Message-----
From: Entena, Raymond
Sent: Thursday, July 29, 2004 10:43 AM
To: '[Email address protected]
Subject: 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