database error - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

database error

Author

Topic

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-05-29 : 07:10:13

Hi,

iam facing a problem in sql database, in particular table i cannot open the table i through the error

Error 924, database 'Smartsystem1' is already open and can only have one user at a time.
table have more than 25000 rows

pls give valuable suggestions

Desikankannan

Kristen
Test

22859 Posts

Posted - 2010-05-29 : 07:36:29

Smartsystem1 is set to Single User.

Find the connection that is using the DB in single user and find out why!!

Change database to Multi User with:

ALTER DATABASE MyDatabaseName SET MULTI_USER WITH ROLLBACK IMMEDIATE

but you may not be able to do that until you have sorted out the connection that has it open in Single User mode already

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-05-29 : 07:53:52

HI
WE DID THAT, BUT THE PROBLEM STILL ON.

Desikankannan

Kristen
Test

22859 Posts

Posted - 2010-05-29 : 12:11:48

Did it change the database to Multi User? If not then, as I said, you need to sort out the connect that currently holds the database in Single User.

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-05-31 : 02:49:55

where i can found , if single user or multiuser
looking forward ur valuable suggestions

quote:
Originally posted by Kristen

Did it change the database to Multi User? If not then, as I said, you need to sort out the connect that currently holds the database in Single User.

Desikankannan

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-31 : 03:56:37

SELECT * FROM sys.databases

--
Gail Shaw
SQL Server MVP

Kristen
Test

22859 Posts

Posted - 2010-05-31 : 04:07:09

[code]
SELECT user_access_desc, name
FROM sys.databases
WHERE name = 'MyDatabaseName'
[/code]

Kristen
Test

22859 Posts

Posted - 2010-05-31 : 04:07:55