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 |
|
BruceT
Yak Posting Veteran
78 Posts |
 Posted - 2011-12-27 : 12:17:43
|
| Hi all,Is there a way to remove the identity property from a column and add it back later? I have a "stupid" situation. I need to insert data into a table from a 3rd party app. The PK is an identity column, the 3rd party app is internally setting Identity insert off so I can't set it on before hand because the app resets it to off so when it inserts it throws the can't insert into an identity column error. (I said it was stupid!) So I need to drop the identity constraint, run the app, then add the identity constraint back onto the column.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
BruceT
Yak Posting Veteran
78 Posts |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-27 : 14:00:17
|
| npyou're wc------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Identity column question