Browse by Tags

SQL 2005 Database Maintenance plan error: Value of 'DD/MM/YYYYHH:MM:SS' is not valid for 'Value'. 'Value' should be between 'MinDate' and 'MaxDate'

Published 9 September 7 3:52 AM | SSQA.net

Here is another common error you will get to see with Database Maintenance plan in SQL Server 2005, though most of it has been resolved with Service Pack 2 and hotfix but still you need to take care few things. Error: Value of 'DD/MM/YYYYHH:MM:SS'...

Filed under: sql server, backup, maintenance plan, database, expiry, reset, value

TSQL to find a login's properties such as password expiration?

Published 23 July 7 7:22 AM | SSQA.net

declare @name nchar ( 100 ) SET @name = '<LoginName' SELECT LOGINPROPERTY ( @name , 'PasswordLastSetTime' ) AS PasswordLastSetTime , LOGINPROPERTY ( @name , 'IsExpired' ) AS IsExpiried , LOGINPROPERTY ( @name , 'IsLocked'...

Filed under: login, password, tsql, expiry, property

Alert particular set of users about PASSWORDY EXPIRY policy notification

Published 23 July 7 3:33 AM | SSQA.net

As you may be aware using SQL 2005 version you can set PASSWORD EXPIRY policy that can apply the same complexity and expiration policies used in Windows Server 2003 operating system to passwords used inside SQL Server. This functionality depends on the...

Filed under: sql server, management, security, mail, login, alerts, password, dbmail, expiry