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.
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.