December 18, 2007 at 1:54 pm
Is there a way to know the password age of the logins in SQL Server 2000?
thx in advance.
Robert.
December 20, 2007 at 9:09 am
You can "guess" by looking at syslogins and check the updatedate. This can change for any number of things, but this would apply for a password change. This gives your a possible age of the passwords.
We've used this and pinged people that haven't changed their pwds in xx days based on this date.
December 28, 2007 at 2:28 pm
figaro,
This should get you started ...
-- SQL Server 2000
-- Column Comments pulled from SQL Server Books OnLine
-- (BOL) topic: sys.logins(Transact-SQL)
-- Selected columns from master.dbo.syslogins Table.
select
createdate -- Date the login was added.
,updatedate -- Date the login was updated.
,name -- Login name of the user.
,loginname -- Login name of the user. Provided for backward compatibility.
,dbname -- Name of the default database of the user when a connection is established.
,isntname -- 1 = Login is a Windows user or group. 0 = Login is a Microsoft SQL Server 2005 login.
,isntgroup -- 1 = Login is a Windows group.
,isntuser -- 1 = Login is a Windows user.
from master.dbo.syslogins
order by updatedate asc
"Key"
MCITP: DBA, MCSE, MCTS: SQL 2005, OCP
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply