ID Number: Q78360
1.11
OS/2
buglist1.11
Summary:
Problem ID: PRSQL9111002
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 version 1.11 that causes a 924
error 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 SQL Server version
1.11. We are researching this problem and will post new information
here as it becomes available.