BUG: Message 511 After Running Stored Procedure

• Microsoft SQL Server version 4.2 for OS/2
• Microsoft SQL Server, version 4.2

       NT:  892 (4.2)

SYMPTOMS

When you execute a stored procedure under SQL Server 4.2, error message 511 is displayed:

   Updated or inserted row is bigger than maximum size ( < number>
   bytes ) allowed for this table.

   Attempt to insert the value NULL into column '<column name>',
   table'<tablename>'; column does not allow nulls. Update fails.

CAUSE

A stored procedure that uses temporary tables may be invalidated when a new object is added to the model database and the SQL Server is shutdown and restarted. When tempdb is rebuilt, the new object in the model database becomes an object in tempdb as well. This new object grabs the object ID the stored procedure was using to reference the temporary table. If one new object in model is added, then one stored proc may be invalidated. If two objects are added, then two references to temp tables in stored procedures may be invalidated, and so on.

WORKAROUND

To correct the problem, simply drop and recreate the affected stored procedure. The INSTMSTR.SQL and INSTCAT.SQL script files may be used to rebuild the system and catalog stored procedures, respectively. You need to stop and restart SQL Server for the changes to take affect.

STATUS

Microsoft has confirmed this to be a problem in SQL Server version 4.2 for OS/2 and Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.