Microsoft KB Archive/153995

= BUG: Error 3307 Creating sproc or view with Existing Name =

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.