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
fine but when simultaneous user access of that stored procedure it giving
error like #Temp table is not exists...

any idea ?

Thanks


.

Relevant Pages

  • Re: proxy account
    ... Another option is to create a stored procedure that executes ... by dbo and the database is owned by sa, you could grant ... >>without giving them sysadmin server role permissions? ... >>of giving a user access to the cmdshell without sysadmin ...
    (microsoft.public.sqlserver.security)
  • Temporary Access to Create Tables
    ... I need to be able to grant to a user access to create a table, then revoke ... I'd like to do this within a Stored Procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: Temp table.
    ... Andrew J. Kelly SQL MVP ... temprary table and droping table at the end, when single user access it is ...
    (microsoft.public.sqlserver.clients)
Loading