Dammit, I ticked Enterprise and clicked the submit button without thinking. I knew Developer was supported....... Having a bad couple of days :crying:

I got this wrong, i went for A. Excellent question and one that I should have answered correctly since I have been reading up on this topic recently. ...

Easy 2 points today! Good question though and a topic that every DBA should be familiar with.

Chad Crawford (3/3/2010)

---

I have no problem with the question - I think the assumptions that needed to be made although not clear, were reasonable.

I do have a question about...

I'm of the opinion that it should be clear exactly what the question is testing for. If the author had specified SQL Server 2005 or 2008 and created a...

A poorly conceived question. I'm not entirely sure of the authors intention.

From what you've said, your connection will possibly sustain mirroring with automatic failover, if you have another SQL Server you can use as a witness (this can be a SQL...

Set NOCOUNT ON

select @@ROWCOUNT

select @@ROWCOUNT

This will return 0,1 (at least on my 2005 server)

It returned 1,1 on SQL 2005

I want my point back 🙁

Although you can script the backups / Maintenance Tasks and execute them using windows scheduled tasks.

Read Books on Line and MSDN until your eyes bleed. Set up a test environment, preferably virtualised (in case you break it) and practice what you read.

Also buy and...

Personally I can't see the cause for complaint. I didn't understand how the bitwise & and | operators worked so I thought I was toast, then I noticed the...

As did mine. I want my point back :crying:

I didn't, although I should have.:Whistling: Overlooked the fact that the constraint was clustered. Good question 😛

It's a SQL Server 2005 or above question pal. It won't work on 2000. That wasn't very clear in the question though.