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: Friday, August 29, 2014 8:46 AM
Points: 6,783, Visits: 1,881
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: Yesterday @ 12:59 AM
Points: 1,220, Visits: 570
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: 2 days ago @ 11:26 AM
Points: 13,622, Visits: 10,514
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: Thursday, July 17, 2014 4:57 AM
Points: 239, Visits: 69
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: 2 days ago @ 3:43 AM
Points: 875, Visits: 2,800
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: Tuesday, August 12, 2014 11:45 PM
Points: 562, Visits: 887
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: Thursday, August 28, 2014 1:00 PM
Points: 4,196, Visits: 3,235
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 6:45 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, August 28, 2014 1:37 PM
Points: 2,677, Visits: 215
I got different results but I was not connected as sysadmin. I hate it when the answer says something like "this assumes..." If it assumes then just tell us so we don't have to assume.
Post #1579595
Posted Wednesday, June 11, 2014 7:04 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, August 27, 2014 7:22 AM
Points: 333, Visits: 366
Fun questions, thanks!
Post #1579601
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse