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