BUG: Message 511 After Running Stored Procedure

ID: Q96768

The information in this article applies to:

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


BUG# OS/2: 1495 (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.

Other errors may also appear, such as error 515:

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.

Additional query words: Windows NT

Keywords : kbprg kbbug4.20 SSrvServer SSrvWinNT
Version : 4.2 | 4.2
Platform : OS/2 WINDOWS
Issue type :