Link to home
Start Free TrialLog in
Avatar of tygerwoods
tygerwoodsFlag for United States of America

asked on

how can I list the login users for sql server using vb.net

I would like to be able to compare the login name for my app to the login name for my sql server, I know the names are in the security section, but don't really have a good idea on how to list them in my applcation.

Thank you
ASKER CERTIFIED SOLUTION
Avatar of maradam
maradam

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
try

select * from sys.sql_logins
Avatar of tygerwoods

ASKER

Maradam
That was a very fast response, I thank you very much. that worked just the way I wanted it to.

Thank you again