with these values you are still doing almost...

Paul White NZ (3/21/2010)

Not quite the same, at least not exactly....

Tracey, the code I gave you will commit every 10000 rows because thats the value set for rowcount. As your log is in simple mode it will automatically truncate that...

do you mean using 10GB of tran log?

do this as a crawler delete, something like this, so tran logs can be backed up

Declare @num int

Set @num = 1 ...

Then I would have thought you would prefer to still use SSMS when the server is in single user mode? Its got to be easier than sqlcmd especially if typing...

if you had not set the 'open new query window' as your startup mode option up front before restarting SQL in single user mode then yes object explorer would gave...

it sounds like you want to restore your master database for which you have to start the instance in single user mode, not set the database to single user. see...

CirquedeSQLeil (3/19/2010)

Paul White NZ (3/19/2010)

Me too, but it's not terribly important. There could have been another option..."it depends".

For the record, I ticked...

oops should have found that! thanks for the pointer, I have subscribed to the thread to keep an eye on it.

I does sound like its possibly in the guys database...

buy the MS SQL SERVER 2005 Implementation and Maintenance training Kit. That will get you 15% off the exam price.

I don't think I am giving away the farm if I say that if the answer boxes are square there is more than one correct answer, a radio button means...

when the answer to the question starts with the phrase 'As I see it............', what chance have we got! 🙂

Other than that I'm in agreement with what Jason said...

ensure no connections to the databases and backup systemdbs before you start, including resource database

In reply to Quote: The problem with socialism is that you eventually run out of other people’s...

Thanks for the 2 points!

Only 54% correct so far, there's too many devs on this site! So its good they learnt something important 😀 😉