Thanks guys! (of course, right before you responded, my co-worker just tanked the install by doing a bunch of "lets see if this does it". ugh.) Looks like I'm gonna need to start a pot of coffee. ;P
::brendan avery 2.0 ::310.779.2211 ::[EMAIL PROTECTED] ::santa monica, california -----Original Message----- From: Peter Tilbrook [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 10, 2002 19:14 To: SQL Subject: RE: Single-User Mode" in SQL Server 7.0 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 ______________________________________________________________________ Macromedia ColdFusion 5 Training from the Source Step by Step ColdFusion http://www.amazon.com/exec/obidos/ASIN/0201758474/houseoffusion Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
