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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-01 : 01:06:40
|
| Stephen writes "I have a database that I manipulate via a VFP client.I designed the database from the enterprise manager console.The design was done under MSSQL 7.0, since then the serverhas been upgraded to MSSQL 8.0 (2000). This upgrade was notperformed by me, but by another contractor. Just for one table in the database, when accessed for recordinsertion or modification I receive the following complaintfrom the server, "IDENTITY_INSERT IS SET TO OFF...". It goeson to say set the property to on and retry.The table has an identity key defined (auto-increment by one).How do I turn this IDENTITY_INSERT property on either viaSPT or through the console?v/rSteve" |
|
|
|
|
|
Indentity_insert property