September 15, 2003 at 11:59 am
is there a way to check to see when the last time the sa password was updated?
September 15, 2003 at 12:57 pm
The updatedate column in syslogins should tell you when changes has been made to the specific login.
September 15, 2003 at 1:13 pm
Not specific to passwords, but usually that's the only change to most logins. It does guarentee the pwd was not changed since that date.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
September 15, 2003 at 1:23 pm
my guys in a panic changed the password so now the last updated field is set to the time they changed it. is there any type of log to track all the times the sa password changed??
September 15, 2003 at 2:57 pm
If you have transaction log backup files and tools to examine the log file, you can do it. See http://www.lumigent.com.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply