BUG: Error 3307 Creating sproc or view with Existing Name

• Microsoft SQL Server versions 6.0 and 6.5

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

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.