In enterprise manager there is a drop down box for that field called "identity" and it is set to NULL by default (even after an import of an autonumber field). Set it to yes. Or... alternately, you can use the alter table syntax to do it ...columnName int Identity(1,1) ... etc.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, February 08, 2002 7: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! ______________________________________________________________________ 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=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
