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.
| Author |
Topic |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-10-01 : 03:18:08
|
| Hi All,I am using SQL Server 7. I wanted to run some updates in database, so changed database option to single user in QA using sp_dboption.But when i run update script in same connection, it was showing error the database is offline or it is already opened. what should be the reason? I tried to stop and start the server. And when i tried to change it to multiple user, it was showing the same error message.And the strange thing is, i closed QA and opened Enterprise Manager, and from database properties, i chenged single user option, it allowed me to change.Does QA uses multiple connections?Thanx in advance.---------------------------Sandesh - The Messanger |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-10-01 : 10:38:04
|
| One connection per window in QA....Are you still stuck?Brett8-)SELECT @@POST FROM Brain ORDER BY NewId()That's correct! It's an AlphaNumeric! |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-10-01 : 13:11:10
|
| Try looking at master..sysprocesses to see what has a connection to the database.You can also use the profiler to see the connections being created.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Single User Mode