Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/171914

From BetaArchive Wiki
Knowledge Base


BUG: Sysprocedures Deadlocks Using Views After Database Load

Article ID: 171914

Article Last Modified on 10/3/2003



APPLIES TO

  • Microsoft SQL Server 6.5 Standard Edition



This article was previously published under Q171914

SYMPTOMS

BUG #: 17101

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: kbbug kbusage KB171914