SQL Server


Storing sp_configure settings in a stored procedure

All SQL Server DBAS are familiar with sp_configure to change the instance global settings. However when you need to modify temporarily those settings from within your code, such as storing sp_configure settings in a stored procedure, the process can become awkward You need to store the configuration setting you change […]

instmdb sql file excerpt

SQL Server Logo

‘MEDIALAYOUT’ in SQL Server ConfigurationFile.Ini 5

While trying to install new instance of SQL Server using command line and the ConfigurationFile.ini unattended answer file, you may receive the following error message : MEDIALAYOUT in SQL Server ConfigurationFile.Ini Don’t waste your time searching in different documentations about the allowed keywords for the configuration file. This error means […]


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 […]