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 |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2014-05-08 : 04:29:49
|
| Hello all,I have the same stored procedure under the same databases in 2 different server (Development and Test). If I modify (with ALTER) the stored in Development (also without any change) I got this error: An explicit value for the identity column in table 'cjeipLog..tMainDocuments' can only be specified when a column list is used and IDENTITY_INSERT is ON.If I alter the stored in Test environment, it successfully complete. The tables and the stored are exactly the same. Why this happens? Thanks a lot. Luis |
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2014-05-08 : 04:38:00
|
| Are any triggers?sabinWeb MCP |
 |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2014-05-08 : 05:02:33
|
| No, there aren't.L |
|
|
|
stepson
Aged Yak Warrior
545 Posts |
Posted - 2014-05-08 : 06:38:57
|
| You can verify the table 'cjeipLog..tMainDocuments' if it has (on Dev and Test env) an identity column .Seems that you try to insert value into a identity columnCan you post,here, the definition of the stored procedure , and table (from Dev and from Test) ?sabinWeb MCP |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2014-05-08 : 10:49:35
|
| Hi Sabin,the problem was due that the tables are different. Who send me the definition of the 2 tables get the values from the same database. Sorry for that, but thanks a lot all the same. Luis |
|
|
|
|
|
|
Alter stored with error on identity insert