Paul,

Very good question, but (yes there has to be right?)

When you use the term "default". By "default" SQL Server tries to create a PK as a clustered index. There already...

Oleg,

Thanks for the explanatin. You're right - I did not have any nulls.

Good question - Thought that I knew the answer, and was wrong. Now, I have a question. I ran the following against an existing database to prove/disprove the answer, and...

Great QOD Paul. Really had me digging deep, and ALMOST got me:-)

:exclamationmark: I have a definite problem with this QOD. WHICH VERSION? When the version is missing, I assume that the question is referencing the most current version and not the...

Yes, it was me reading more into it - probably because it happens so often.

Sorry Matt

I thought it was a good question. It caused me to think and read a couple of times to make sure of what I was reading. It also caused me...

Great question - got it wrong, but caused me to think.

Another possible issue/solution, probably under possibility 1:

I get a lot of SAN detatch errors from a certain iSCSI SAN. The SAN Drives will drop, and reattach. Fortunately, the Windows OS...

Chad - You got me thinking.

I opened an OSQL session in DOS to a SS2K5 box, and running the code as is got the 0,1 answer.

BUT - how many people...

I have tried this code on both SS2K5 and 2K. Both are default installations.

On 2K I got the 0,1 and on 2K5 I got 1,1.

The question does not specify version,...

I too had to guess. Got it right only because I new the others were wrong. Never saw this wild card before, and look forward to using it.

Thanks for the...

To Timfle and VK:

Tim, I for one take great offense as to your "SARCASM", it is truely non-professional, from an individual who claims to have so much time being professional.

Both:...

VK:

For MSSQL 2000, the default size of model's MDF is 768 KB

Sorry - I stand corrected. THe total size of SS2K and earlier is 2MB.

Technically, none of the answers are correct. The default size of a newly created database is based upon the size of the model database. I haven't worked with 2008, but...