Month: March 2015

Issues with Shrinking or Truncating SIMPLE Recovery Mode Database I had a database with log file size of 30 Gig and Data File with 20 Gig. I wanted to shrink the database but I was not able to . When I ran “DBCC OPENTRAN“, I …

SQL Server Login Properties USE [master] GO SELECT [name] AS [SQL_User] ,LOGINPROPERTY([name], ‘PasswordLastSetTime’) AS [PasswordLastResetDT] ,LOGINPROPERTY([name], ‘BadPasswordCount’) AS [BadPasswordCount] ,LOGINPROPERTY([name], ‘BadPasswordTime’) AS [BadPasswordDT] ,LOGINPROPERTY([name], ‘HistoryLength’) AS [HistoryLength] ,LOGINPROPERTY([name], ‘IsExpired’) AS [IsExpired] ,LOGINPROPERTY([name], ‘IsLocked’) AS [IsLocked] ,LOGINPROPERTY([name], ‘IsMustChange’) AS [IsMustChange] ,LOGINPROPERTY([name], ‘LockoutTime’) AS [LockoutTime] FROM [sys].[sql_logins] …