Showing posts with label wheter. Show all posts
Showing posts with label wheter. Show all posts

Friday, February 24, 2012

About SQL Login

Hi all
Does someone know a strored procedure or any t-sql that lets you know wheter a login is windows or sql authentication ?You can query the following tables:
sysusers for users and syslogins for logins.
You will find columns like issqluser or issqluser.
This columns will inform you if the user (login) is windows or sql user (login).