Article ID: 153995
Article Last Modified on 10/16/2003
APPLIES TO
- Microsoft SQL Server 6.0 Standard Edition
- Microsoft SQL Server 6.5 Standard Edition
This article was previously published under Q153995
SYMPTOMS
If a database is in single-user mode, then an attempt to create a stored
procedure (sproc) or view with an existing name causes error 3307.
In SQL Server 6.0, the following warnings are posted in the error log:
Error : 3307, Severity: 21, State: 1
spid9 Process 9 was expected to hold logical lock on page 8.
spid9 WARNING: Pss found with open sdes; pspid 9, psuid 1, pcurdb 5,
system table entry 0, sdesp 0xb2abc0, objid 8
spid9 WARNING: Pss found with open sdes; pspid 9, psuid 1, pcurdb 5,
system table entry 1, sdesp 0xb29ea0, objid 3
kernel WARNING: Process being freed while holding Dataserver semaphore
In SQL Server 6.5, the application log of the Windows NT event viewer is
filled up with 3307 error messages.
The server becomes very unresponsive and any attempt to kill the offending
query fails.
WORKAROUND
To solve this problem, try canceling the query or killing the spid. If that
does not help, recycle SQL Server.
STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server
versions 6.0 and 6.5. We are researching this problem and will post new
information here in the Microsoft Knowledge Base as it becomes available.
Keywords: kbbug KB153995