Obtaining machine names for failed logins
The SQL Server error log contains invaluable details about failed logins, but only if you enable login auditing. Once enabled, the error log will provide the details of logins that failed including the name of…
How do I store a number with leading zeros?
Many line-of-business applications want to store document numbers with leading zeros, such as an Invoice Number, or Cheque Number. The idea behind having the leading zeros is we’ve predefined the format for the document number…