Skrilla99,

You're absolutely right, main reason for looking at the QODs is to learn. But that's not all. Several things here:

1 - You are awarded points for answering questions correctly. This...

I don't get it.

QUOTE: '..would NOT be a step you would have to follow in SQL Server 2000 when you rename the physical server name?'

Now, would this be the answer:...

I found this question dubious. Even the answer is dubious. It suggests there is another question not mentioned here, namely: what is the best config if redundancy is also an...

I disagree. Licensing is quiet different from building, developing and implementing systems or databases. Ofcourse, dba's will be asked about licensing, but I think this is rarely the case. It...

Precisely my pouint, Frank. Nice, these smileys.

Can somebody tell me why all these licensing questions crop up? How many DBA's are concerned with that? I have worked with many companies over the years, and only once...

So, where do I find info on the DBCC LOCK command? Not in BOL, I don't...

A curious person.

Yes please, where to find info like this? Searched BOL, could not find any mention of this trace flag.

Further more, after creating the table with the script provided in the question, I could not find a constraint in the table. I scripted the table back and this is...

Does this solution(set language) not pose problems for inserts for the inserting dates in US format? I would think a trigger to convert the dateformat as applicable would be better.

Hans...

Maybe I don't understand the question. Using the EM to change the single-user property seems to me a valid option. If I read correctly, the question was what was NOT...

There are several arguments to store SP's outside SQL Server, not 1 of them is touched in the article. The reasons mentioned here are farfetched IMO.

Kind regards,

Hans Brouwer