Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itfanaticus
Starting Member
6 Posts |
 Posted - 2006-03-27 : 16:08:11
|
| I get the following error:Server: Msg 8107, Level 16, State 1, Line 2IDENTITY_INSERT is already ON for table 'MSGC_Main'. Cannot perform SET operation for table 'ContentOutputType_LKP'.I don't even have the table 'MSGC_Main' table specified in my T-SQL!I am flipping the identity_insert on and off accordingly. I'm quite puzzled at the moment. |
|
|
jhermiz
3564 Posts |
Posted - 2006-03-27 : 16:14:52
|
So am I , without providing sample data, sample ddl, table structures and more info we cant really help you.
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2006-03-27 : 16:50:34
|
| Do you have a trigger on ContentOutputType_LKP? |
|
|
|
itfanaticus
Starting Member
6 Posts |
Posted - 2006-03-27 : 17:12:47
|
| Honestly, I thought I wouldn't have to provide anything since I thought the error was going to be a dead give away. I mean, the error relates to a table not present in the SQL :)The SQL is 500 lines. I'm wondering if its even usefull to post it since without a structure diagram, it could be useless? Should I still post it?I've looked at the execution plan and wasn't able to find the table in question either. |
|
|
|
itfanaticus
Starting Member
6 Posts |
Posted - 2006-03-27 : 17:13:20
|
quote:
Originally posted by mmarovic
Do you have a trigger on ContentOutputType_LKP?
No triggers at all. |
|
|
|
itfanaticus
Starting Member
6 Posts |
Posted - 2006-03-29 : 10:41:53
|
| I think it was a caching problem or something. This morning, I decided to try to debug this again and I get other expected error messages. Problem solved it seems. |
|
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-03-29 : 10:55:50
|
| Sounds like someone somewhere set identity_insert on for MSGC_Main and never turned it off. If it happens again try set identity_insert MSGC_Main OFF. If that clears it up then there is some code out there that turns it on but doesn't turn it off.Be One with the OptimizerTG |
|
|
|
|
|
|
Weird problem with insert_identity