Retrieving windows user information from group login

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

I believe the function is SUSER_SNAME() or you can use SUSER_NAME(). For domain logins they return domain\username

Oh, and please don't cross post.

Thanks,

Ron McCullough SSC Guru Points: 63877 More actions · Answer 2

This is identical to the posting by the same individual to SQL Server 2005 Security.

Ooops Jack you sure can type faster than I can ...

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

Jack Corbett SSC Guru Points: 184394 More actions · Answer 3

bitbucket (8/25/2008)
Ooops Jack you sure can type faster than I can ...

Nah, just cut and paste better.:P