> 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.
Open Design Table view:
- clear the Null column on your PK field
- check Identity and
- make sure you've specified it as the Primary Key.
--
Aidan Whitehall <[EMAIL PROTECTED]>
ColdFusion Developer
Fairbanks Environmental +44 (0)1695 51775
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists