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).

No comments:

Post a Comment