Lightening the mood:

I was SO hoping that one of the answers would be "Don't talk about Normalization"

I think the problem is that the question is almost too easy

Saying that, I absolutely LOVED the first option - gave me a good laugh, which occasionally these questions need...

A well detailed question, but the answer is incorrect

As with the others, because of the added apostrophie on line 9, the syntax of the Stored Procedure is invalid

Maybe a little...

Now if only they could get the forum to run at a usable speed, instad of one click every 2-3 minutes

But then again, what do you expect from a message...

The other questions is... what if you have an "authors" table in your current database?

No error or warning thrown then, just the headers...

Think of every scenario and this question will...

Unless the point is to prepare us for dumb-ass questions from staff who do not know SQL Server well enough to think about context...

The one thing that I've learnt today is that when the question starts with "What about this T-SQL?", then there should be answers in the line of "Depending on the...

And detatching the database is like taking that 18 wheeler and blocking all of the highways while you go to the corner market

My...

But the whole point of the question was to leave the database running and online

Detatching it completely goes against this, and breaks the rules of the question

At least using DTS...

I meant "isn't" not "is", but the Edit on this board is broken, so I can't fix my message

I find it humerous that you are concerned with Read Locks when options One and Four take the entire database off-line

As I said "it's a far better method than 1...

I'm just wondering why "use DTS" isn't an option - it's a far better method than 1 and 4...

We have just heard back from our Server hosting guys - the server had been crashing on and off... here's what they said:

it actually appears that MSSEARCH is...

Thanks

Any suggestions can only help

OK, here's something new

If I take over the server with Terminal Services, using the Admin level login, I can build the Full Text Index, but logging in via "sa" using...