Does SP__SERVERPROPERTY exist?

[TheBugSlayer]

Hi all.
This is one the questions I got wrong during exam 70-228 practice test:

You are installing SQL Srv 2K on a Win 2K Ad. Srv machine. Before creating any database, you want to set the security mode for SQL Srv. Which of the following tools or commands will enable you to do so? (Choose all that apply).
1- SQL EM.
2- sp_serverproperty.
3- The Server Roles option under Security.
4- The users options for each database.


I chose (1) only as I have never heard of sp_serverproperty. But the correct answer, according to the exam review, is (1) and (2) even though I still don't find any reference to the procedure anywhere. Not in BOL, not on the net and it doesn't execute in QA...What is the problem?

 

[JayKusch]

Think you, or the test, has that one a bit wrong. ServerProperty is a system function not an SP.

Here is an example of its use ...

SELECT CONVERT(char(20), SERVERPROPERTY('servername'))

Here's a link to chew on too:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sa-ses_3mi1.asp

Thanks

J. Kusch

 

[TheBugSlayer]

Well, not me. I could remember the function but they listed it as a stored procedure, with the SP prefix and all, LOL. Furthermore it does not allow you to change the authentication mode but lists other server properties.

Another thing, the way they ask some questions is a bit unfair. There are many instances where I could argue that my solution is at worst as efficient as what they think is the good one. It really depends on the environment...

As I go along I will be posting some of those.

Thanks for your help.

PS: I bought a practice test from Bosom, that one is even worse in terms of inconsistencies...