Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  stored procedure

Author  Topic  amir Starting Member 12 Posts Posted - 2001-02-20 : 07:39:34 I get this message: Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Driver][SQL Server]Cannot insert the value NULL into column 'id', table 'forum.dbo.messages'; column does not allow nulls. INSERT fails. although I did what you told.the whole SQL statement is : INSERT INTO messages(topic,msg) VALUES('"&request("topic")&"','"&request("msg")&"') and it stored as a stored procedure in SQL SERVER thank's again