You go into enterprise manager depending if you have 2000 or 7.0 it may differ but: right click on the table in question Click Design Table Depending if you have 7.0 or 2000 will depend on where this is located. If you have 2000 it should be at the bottom of the screen you should see something that says IDENTITY it should be set to NO at default change it to yes and you will be good to go. If you have 7.0 instead of identity being at the bottom it may be over towards the right of the screen. Kelly
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 10:36 AM To: CF-Talk Subject: Access to SQL Server In Access you can set the primary key to auto number - how do you do this in SQL Server? I would assume that has something to do with this error that I am getting: Error Diagnostic Information ODBC Error Code = 23000 (Integrity constraint violation) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'UserID', table 'SaraLee.dbo.ChockUsers'; column does not allow nulls. INSERT fails. Thanks! ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists