September 20, 2008 at 10:14 pm
Comments posted to this topic are about the item Security Principals
September 21, 2008 at 8:56 am
Great question ..Now for a trival comment the link shown for the correct answer
Displays a MSDN page titled Using SQL Server Profiler:
However this link http://msdn.microsoft.com/en-us/library/ms188786.aspx yields sys.server_prinicipals(Transact-SQL) produces from BOL for SQL Server 2008
September 22, 2008 at 7:15 am
Thanks, fixed.
September 22, 2008 at 12:45 pm
Good question.
I guess this article relates more to the question than the one posted.
September 23, 2008 at 9:00 am
Nice question....
October 2, 2010 at 9:22 am
Good question.
I was in two minds whether to tick "certificates" or not: after all, Server Level principals like ##MS_PolicySigningCertificate##, ##MS_PolicyEventProcessingLogin##, and so on are certificate derived, some even include "Certificate" in their names, and given the general standard of questions I thought that there was an even chance that the question setter didn't distinguish these principals from the certificates from which they are derived. So I flipped a mental coin and came up with the wrong answer. If I'd known Steve had set the question I would have chosen differently. 😉
Tom
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply