Identity_insert problem
When I am tryin to use identity_insert for first table(Master)...the function is working...but then after gettin redirected to Employee table, when again I am tryin to execute the query --
Set Identity_insert Employee On
then it is showing me error -- Microsoft OLE DB Provider for SQL Server (0x80040E14)
IDENTITY_INSERT is already ON for table 'company_information.dbo.Master'. Cannot perform SET operation for table 'EMPLOYEE'.
What shud I do??
And if I turn off the identity_insert for Employee then it gives me an error -- Identity_insert is set to off for table employee.
Whats the solution?? :(
|
