If you mean local temp tables defined by a single # sign and local
cursors, then no, each object is created for the local user and for each
execution, even if called multiple times, synchronously.

As long as the calls are against different objects, then there shouldn't
be locking contention either.

Sincerely,


Anthony Thomas, MCDBA, MCSA


-----Original Message-----
From: Entena Raymond
[mailto:mssqldba-ezmlmshield-x1188716.[Email address protected]
Sent: Wednesday, July 28, 2004 9:43 PM
To: LazyDBA Discussion
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






---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]




***********************************************************************
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the
individual or entity intended as the recipient. If you are not the
intended recipient, any use, copying, printing, reviewing, retention,
disclosure, distribution or forwarding of the message or any attached
file is not authorized and is strictly prohibited. If you have received
this electronic mail message in error, please advise the sender by reply
electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your
computer system.
***********************************************************************

MS Sql Server LazyDBA home page