HKEY_LOCAL_MACHINE/SOFTWARE/Microsoft/Microsoft SQL Server/MSSQL.1/MSSQLServer/LoginMode

This is the right answer.

The wrong answer by the site is the right answer

KMSonti

The first answer is the correct one. i.e.

sp_tableoption N'Employee', 'text in row', '2000'

Eventhough the other one with two statements is also correct, it is verbose.

Elegant way is...

The article was good.

Of all the ways,

SELECT SERVERPROPERTY('ProductLevel')

would be of much use as it tells what SP you are running, which most people want rather than version number.

And there...

Andy,

Could you elaborate on 'logging code to each proc'?.

I could not get what you mean by logging?

Thanks.