If you are using SQL Enterprise Manager, in design mode, click on the
Identity option and set it to Yes. Optionally, you can set the seed as
well.
----- Original Message -----
From: "ibtoad" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, June 13, 2001 10:36 AM
Subject: OT SQL Server
> I have a simple question. How do you set the primary key field to
> autonumber in SQL server? I have always used Access where this is a
choice
> but don't see how to do it with SQL Server 2000.
>
> Thanks,
> Rich
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
