BUG: Sysprocedures Deadlocks Using Views After Database Load

ID: Q171914

The information in this article applies to:

• Microsoft SQL Server, version 6.5

SYMPTOMS

After a database has been restored from a backup, deadlocks occur on sysprocedures when multiple connections run multiple concurrent queries against the same set of views.

The same queries, run in the same way, succeed when run a second time.

WORKAROUND

To work around this problem, do either of the following:

• Run a single query against each view to complete object resolution before allowing multiple concurrent access to the views.
• If the connections are running a batch of queries against views, run the queries individually with a 'go' between each in the batch.

STATUS

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

Additional query words: av access violation

Keywords          : kbusage SSrvGen kbbug6.50 
Version           : 6.5
Platform          : WINDOWS
Issue type        : kbbug

Last Reviewed: August 1, 1997