August 29, 2007 at 7:43 am
Is there a query or set of queries I could use that would tell me if the user passwords are "mixed mode", "sql authentication", or "windows authentication" and also if they are set to "enforce password policy", "enforce password expiration", and "user must change login at next login"?
Possibly telling me how to do these things through t-sql would also allow me to find the locations within the database. I would assume they are in the master database, but I wouldn't know where to begin looking other than that. Thanks for any help.
-Kyle
August 29, 2007 at 8:16 am
select * from sys.database_principals
select * from sys.sql_logins
Regards,
Andras
August 29, 2007 at 8:59 am
I'm sorry, I forgot to mention that I would like this to work on both SQL Server 2000 and 2005
-Kyle
August 29, 2007 at 9:23 am
On SQL Server 2000 use:
select * from syslogins
select * from sysusers
Note that the password policy is not relevant to 2000.
Regards,
Andras
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply