Microsoft KB Archive/78360

= BUG: Msg 924 When Running Stored Procedure =

Article ID: 78360

Article Last Modified on 2/14/2005

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition

-



This article was previously published under Q78360



BUG# NT: 875 (4.2)



SYMPTOMS
When attempting to run a stored procedure, the following error message is returned:

Msg 924, Level 14, State 2

Database 'dbname' is already open and can only have one

user at a time.



CAUSE
There is a problem in SQL Server versions 4.2, 4.21 and 4.21a that causes a 924 error message to be generated when an attempt is made to run a stored procedure. The error is generated only if the database is in single user mode, and if the creator of the stored procedure was not the first user to run it.



WORKAROUND
To avoid this problem, ensure that the creator of a stored procedure runs that procedure following its creation.



STATUS
Microsoft has confirmed this to be a problem in Microsoft SQL Server version 4.2. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

Keywords: kbprogramming KB78360

-

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

© Microsoft Corporation. All rights reserved.