i couldn't log on to sql server from the client. i then looked at the
database and there was a single user description next to the database name
label. I then closed the server and opened it back up, and the description
disappeared and was then able to login as though nothing had happened. what
would cause this?

our backup system doesn't start until midnight so it couldn't have been it.
thank you for any ideas.

On Tue, 13 Jun 2006 21:57:02 -0700, ae wrote:

Hi ae,

ALTER DATABASE databasename SET SINGLE_USER

In SQL Server 2005, this statement can only be executed if you have
ALTER permission on the database.

In SQL Server 2000, this statement can only be executed by members of
the sysadmin and dbcreator fixed server roles, and to members of the
db_owner fixed database role.

--
Hugo Kornelis, SQL Server MVP

Hi,

You can alter the database state to restrict the access to the single user
mode and change it back to multi user mode by sql commands as well as the
Enterprise manager or the sql server management studio.
You can read the article about single and multi users modes at link :
http://www.kodyaz.com/articles/alter...user-mode.aspx
And also you can use the sql script to kill all processes running on a
database which you can find at http://www.kodyaz.
com/articles/kill-all-processes-of-a-database.aspx

Eralper