Skip to Content.
Sympa Menu

freetds - Re: IDENTITY_INSERT ON

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Geoff Winkless" <geoff AT farmline.com>
  • To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
  • Subject: Re: IDENTITY_INSERT ON
  • Date: Wed, 11 Oct 2000 14:37:40 +0100


"Blair Colbey" <colbey AT dreamwerx.net> writes:
> If you want to specify the ID (probably not reccommended to ensure no
> duplicates, etc) you will need to unclick the identity column in mssql
> server enterprise manager, table design mode for the ID column.

Or use

set identity_insert on adresse

(or it might be set identity_insert adresse on, can't remember the exact
syntax)

Remember to turn it OFF again :)

Geoff





Archive powered by MHonArc 2.6.24.

Top of Page