sql database problem - 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

General SQL Server Forums

New to SQL Server Administration

sql database problem

Author

Topic

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-05-29 : 07:28:44

we have using sql2000 server
we face the problem database could not open the database

error message
ALTER DATABASE failed because a lock could not be placed on database 'smartsystem1'. Try again later.

Desikankannan

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2010-05-30 : 23:06:35

lookfor any session opened for that database

Arnav
Even you learn 1%, Learn it with 100% confidence.

desikankannan
Posting Yak Master

152 Posts

Posted - 2010-05-31 : 02:51:45

did'nt get you

quote:
Originally posted by sunsanvin

lookfor any session opened for that database

Arnav
Even you learn 1%, Learn it with 100% confidence.

Desikankannan

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-05-31 : 03:51:05

You won't get that just trying to connect to the database, there's an ALTER DATABASE statement running. What are you trying to do?

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources