SQL Server


Could not obtain information about Windows NT group/user ‘domain\user’, error code 0x5

When getting this error message Could not obtain information about Windows NT group/user ‘domainname\username’, error code 0x5 in SQL Server you may be wondering what’s happening. This error message can happen in numerous occasions and while executing different T-SQL Statements, such as xp_logininfo

Or while executing sp_xp_cmdshell_proxy_account while you […]


Automated maintenance for SQL Server Express

One of the drawbacks of using Express Editions of SQL Server is the lack of working SQL Agent Jobs. In particular when you are using Ola Hallengren’s excellent maintenance solution for backups and other maintenance tasks. His FAQ just suggests that you use sqlcmd to execute the stored procedures, but […]