SQL Server will not start: the user has not been granted the requested logon type. No ERRORLOG, because Windows refused. Also error state 10013.
How to Change Owner of Database in SQL SERVER? – Interview Question of the Week #117
How do you change owner of a database in SQL Server? Three ways, including ALTER AUTHORIZATION, which I prefer, and the deprecated sp_changedbowner.
SQL SERVER – Script to Audit Login and Role Member Change
A script to audit login and role member changes in SQL Server, tested end to end, including the failed attempts most people never think to capture.
SQL SERVER – Log Shipping Copy Job Failure – The Password for This Account Has Expired
A reader’s log shipping copy job was failing with ‘The password for this account has expired’. Here is how we found the cause and fixed it.
When was Domain Account Password Changed in SQL Server? – Interview Question of the Week #093
Error 1069, logon failure, often means the service account password changed in the domain. Here is how to find when a Domain Account Password was last changed.
PowerShell – Create a User with Read Rights on a Database
A DBA kept creating database users by hand. Here is a simple PowerShell and SMO script to create a user with read rights on a database.
SQL SERVER – How to Find Out When Your SQL Login Will Expire?
A client wanted a script to show when each SQL login will expire. LOGINPROPERTY makes it easy on SQL 2008 onwards. Here is the query I used.