Click to See Complete Forum and Search --> : Temp table permissions


Andrew
03-17-2000, 12:07 PM
I recently migrated from MSSQL 6.5 to MSSQL7.0 and have the following problem
with a stored procedure:

-->
Server: Msg 8104, Level 16, State 1, Procedure sp_Match_BankNo, Line 117
The current user is not the database or object owner of table '#tmp'. Cannot
perform SET operation.
--#

The stored procedure creates a temporary table

create table #tmp
(
ID INT IDENTITY(1,1)
...
...
)

and then calls

SET IDENTITY_INSERT #tmp ON

to allow an insert of a row with a previously generated ID.

Any quick ideas or solutions???

Thanks in advance.