• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 181
  • Last Modified:

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
1 Solution
select name from sys.server_principals where type in ('S','U')
order by name

select * from sys.sql_logins
tygerwoodsAuthor Commented:
That was a very fast response, I thank you very much. that worked just the way I wanted it to.

Thank you again
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now