A while ago, I published a post to slipstream the SQL Server 2008 media. It is time to update it for SQL Server 2019. Fortunately the setup.exe hasn’t changed much, so it is still a matter of: Copying the RTM ISO on a read-write filesystem Unpack the Cumulative update of […]
What is the length of a SQL Server instance name, the invalid characters, and also for a Windows machine machine
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 […]
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 […]
When receiving this error message: ” Error : Your SQL Server installation is either corrupt or has been tampered with (Error getting instance ID from name.). Please uninstall then re-run setup to correct this problem, it is likely you are trying to start SQL Server as a regular binary or as […]
Under some circumstances, your SQL Server Agent job mail fails with the following error message: “Unable to start execution of step 1 (reason: The job step contains tokens. For SQL Server 2005 Service Pack 1 or later, you must use the appropriate ESCAPE_xxx macro to update job steps containing tokens […]
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
|
1 2 |
Msg 15404, Level 16, State 19, Procedure xp_logininfo, Line 64 Could not obtain information about Windows NT group/user 'domain\user', error code 0x5. |
Or while executing sp_xp_cmdshell_proxy_account while you […]
Sudden slow SQL symptom If you have installed SQL Server on a Windows 2008 R2 OS, you may receive calls from your users complaining about slow SQL. All your queries are becoming suddenly slow. THat’s a standard rant. But what is strange is it doesn’t affect user stored procedures only. […]
As already mentioned in this post, Ola ‘s solution to backup your SQL Server databases is recognized as a easy-to-deploy, no stress, solution. You can easily build on top of it. Without installing any SQL cmdlet nor looking in the table the scripts produce, here is a solution to get […]
Some of the recommendations for better administering the logs of a SQL Server include adding more logs than the default value of 6 executing a periodic rotation at a given point in a time instead of relying of the system only Here are then a few snippets to perform […]
