Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 123»»»

Status and Name Please Expand / Collapse
Author
Message
Posted Tuesday, June 10, 2014 11:09 PM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 9:27 AM
Points: 6,800, Visits: 1,917
Comments posted to this topic are about the item Status and Name Please

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1579463
Posted Tuesday, June 10, 2014 11:10 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Good one, Andy. Thank you.

---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1579464
Posted Wednesday, June 11, 2014 12:02 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 4:06 AM
Points: 1,392, Visits: 665
Great question, I liked this one, definitly learnt somthing new 2day about those SUSER_SNAME() & USER_NAME() functions, Thanx Andy.
Post #1579468
Posted Wednesday, June 11, 2014 12:17 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 7:44 AM
Points: 13,562, Visits: 11,372
Yet another great question thanks.

The page USER_NAME (Transact-SQL) does mention that dbo is returned for sysadmins in example B.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1579473
Posted Wednesday, June 11, 2014 12:33 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, November 24, 2014 1:26 AM
Points: 247, Visits: 77
I need to study more about USER_NAME() and SUSER_SNAME() functions

Thanks
Post #1579482
Posted Wednesday, June 11, 2014 12:35 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 9:54 AM
Points: 975, Visits: 3,036
Good question, and I agree with Koen. The help page at http://technet.microsoft.com/en-us/library/ms188014.aspx does tell you that dbo is returned for members of sysadmin.

Here is the result set for a user that is a member of the sysadmin fixed server role.
------------------------------
dbo





The SQL Guy @ blogspot

@SeanPearceSQL

About Me
Post #1579485
Posted Wednesday, June 11, 2014 12:41 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Yesterday @ 11:46 PM
Points: 569, Visits: 903
It is nice way to learn new things.Thanks Andy.

--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1579486
Posted Wednesday, June 11, 2014 6:05 AM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 11:35 AM
Points: 4,482, Visits: 3,938
Nice question, Andy. Good way to wake up the brain in the morning. Thanks.


Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
Post #1579583
Posted Wednesday, June 11, 2014 7:04 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:12 AM
Points: 400, Visits: 424
Fun questions, thanks!
Post #1579601
Posted Wednesday, June 11, 2014 7:33 AM
SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: Moderators
Last Login: Yesterday @ 9:27 AM
Points: 6,800, Visits: 1,917
About the assumption, I'm not sure it was good to have in the answer, because the question had "You're the DBA with sysadmin access". But thinking beyond that, sometimes I want readers to infer things about the question. That makes it harder, more interesting, and less of a pure test taking skill question (maybe). Is infer better than assume? "This question depends on the reader correctly inferring..." vs "This question depends on the reader correctly assuming...". Reading those two, I think I do like infer better, as it does point toward derived knowledge and not just "I'm doing the SSC question of the day which means I'm an SA".

Andy
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
Post #1579617
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse