Re: Temp table.

From: "Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx>
Date: Wed, 12 Apr 2006 20:03:34 -0400

Can you post the actual code?

--
Andrew J. Kelly SQL MVP

"Rogers" <naissani@xxxxxxxxxxx> wrote in message
news:uGPf4ZmXGHA.3704@xxxxxxxxxxxxxxxxxxxxxxx

Is there any one let me know, in the stored procedure I am creating
temprary table and droping table at the end, when single user access it is
working fine but when simultaneous user access of that stored procedure it
giving error like #Temp table is not exists...

any idea ?

Thanks

Follow-Ups:
- Re: Temp table.
  - From: Rogers

References:
- Temp table.
  - From: Rogers

Prev by Date: Temp table.
Next by Date: Re: Temp table.
Previous by thread: Temp table.
Next by thread: Re: Temp table.
Index(es):
- Date
- Thread

Relevant Pages

Temp table.
... Is there any one let me know, in the stored procedure I am creating temprary ... table and droping table at the end, when single user access it is working ...
(microsoft.public.sqlserver.clients)
Re: Temp table.
... Andrew J. Kelly SQL MVP ... @StartDate DATETIME, ... EntityspecificID INT, IsLock BIT,'+@Col+',TotalAmount AS ... temprary table and droping table at the end, when single user access it ...
(microsoft.public.sqlserver.clients)