FIX: Unexpected Behavior During Object Resolution

ID: Q134659

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0

Bug#: 10252 (6.00)

SYMPTOMS

During object resolution, Microsoft SQL Server version 6.0 may not successfully resolve the dependency, which can cause a thread access violation.

There are several variations of the behavior depending on whether you are using a view or a stored procedure, and, more specifically, user created objects. User created objects induce errors with stored procedure resolution.

There are two basic situations. First, the table is created, a view or stored procedure is created to reference the table, and then the table is dropped.

The second situation is the same as the first, only the table is re- created. In general, you would expect the first scenario always to error because the object no longer exists, and the second to resolve the table change.

However, the following chart lists the different scenarios that lead to unsuccessful outcomes. The first scenario is referred to as NOTBL and the second outcome is referred to as WITHTBL.

Table created by: dbo
View create by: dbo

Test run by user: dbo

NOTBL:

Version: 6.0
The first dbo connection that attempts to execute the view receives
error message(208):

The second dbo connection receives a thread access violation and the SQL Server hangs, meaning no new connections are accepted by the SQL Server until it is stopped and restarted.

Version: 4.21a
Continues to receive error message (208):

and 4413 error messages.

Table created by: dbo
View create by: dbo

Test run by user: test_user

NOTBL:

Version: 6.0
The first dbo connection that attempts to execute the view receives error message (208):

and 4413 error messages.

Table created by: test_user
View create by: test_user

Test run by user: test_user

NOTBL:

Version: 6.0
The first dbo connection that attempts to execute the view receives error message (208):

and 4413 error messages.

Table created by: test_user
View create by: test_user

Test run by user: dbo

NOTBL:

Version: 6.0
The first dbo connection that attempts to execute the view receives error message (208):

and 4413 error messages.

WITHTBL:

Version: 6.0
The first dbo connection that attempts to execute the view receives error message (208):

Test run by user: dbo

WITHTBL:

Version: 6.0
Continues to generate error message (208):

and never resolves the dependency.

Version: 4.21a Successful resolution

WORKAROUND

Drop and recreate the object(s) which rely on the missing or changed dependency object.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server versions 4.21a and 6.0. This problem was corrected in Service Pack 1 for SQL Server version 6.0. For more information, contact your primary support provider.

Additional query words: sql6 trigger res_view Windows NT

Keywords : kbusage SSrvProg kbbug6.00 kbfix6.00.sp1 SSrvWinNT
Version : 4.21a 6.0
Platform : WINDOWS
Issue type :