BUG: Error 3307 Creating sproc or view with Existing Name

ID: Q153995

The information in this article applies to:

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          : kbbug6.50 kbbug6.00 
Version           : 6.0 6.5
Platform          : WINDOWS 
Issue type        :

Last Reviewed: April 1, 1999