That's great! I tried looking on the SQL site and couldn't find anything! Thanks Kelly!
-----Original Message----- From: Kelly [mailto:[EMAIL PROTECTED]] Sent: Friday, 11 January 2002 2:08 PM To: SQL Subject: RE: Single-User Mode" in SQL Server 7.0 Yes go into enterprise manager, go to the database in question, right click, click properties. Click on the Options tab. Then where it says Access click the Restrict Access box. Then that will allow you to click single user. Single user mode basically prevents anything or anyone, other than the current user/process, from accessing or querying against the database. -----Original Message----- From: Brendan Avery [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 9:58 PM To: SQL Subject: Single-User Mode" in SQL Server 7.0 Anybody know what "Single-User Mode" means with relation to SQL Server 7.0 and how to activate it? We're trying to "restore" the "master" database and it pops up a dialog saying we need to be in "Single-User Mode". ::brendan avery 2.0 ::310.779.2211 ::[EMAIL PROTECTED] ::santa monica, california ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
