how to see server logins

Question

Viewing 8 posts - 1 through 7 (of 7 total)

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

kgunnarsson Ten Centuries Points: 1218 More actions · Answer 1

suser_id()

suser_name()

functions are what you are looking for i think ?

if not you may need to be more specific

kgunnarsson
Mcitp Database Developer.

jagpalsingh4 Ten Centuries Points: 1311 More actions · Answer 2

hi

thaxx for reply but i just want to know that how we can see all users

login id .like we can see through management studio we just go to security and we can see all users but how can we see through t-sql

Big Data Man SSCrazy Eights Points: 8536 More actions · Answer 3

Hey,

sp_who or sp_who2

Cheers,

Phillip Cox

MCITP - DBAdmin

Piotr.Rodak SSCrazy Eights Points: 9376 More actions · Answer 4

is this what you are looking for?

select * from sys.syslogins

or

select * from sys.server_principals

Piotr

...and your only reply is slàinte mhath

kgunnarsson Ten Centuries Points: 1218 More actions · Answer 5

true.. the correct answer would be sys.sql_logins

kgunnarsson
Mcitp Database Developer.

Steve Jones - SSC Editor SSC Guru Points: 736162 More actions · Answer 6

sql_logins only gives you some of the logins for the server.

All logins are in server_principals./

jagpalsingh4 Ten Centuries Points: 1311 More actions · Answer 7

Ten Centuries

Points: 1311

March 10, 2008 at 8:40 am

hi,

thaxx for nice answer

regards

jagpal singh