Database Solutions

How to Batch Control xp_cmdshell function on Multiple SQL Servers

xp_cmdshell is a handy function and allows SQL Server database administrators to complete tasks quickly and get transformed as a proactive and efficient database administrator. However, it also allows the user to run windows programs using the SQL Server's service account. In this article, you will learn how to control the status of xp_cmdshell from your Central Server. On a single server To check the status of xp_cmdshell on a single SQL Server instance, you can run this command from a new...

Read more »

How to Find the Reason Why TempDB is Full in Your SQL Server

If the temp DB database of your SQL Server runs out of space, it can cause major disruptions in your production environment and can interrupt user applications from successful completion. If you are using a script to track temp DB size, append the script from this article to identify the root cause for the temp DB filling. Tempdb full – a common scenario Poorly written queries might create several temporary objects resulting in a growing tempdb database. This will end in disk space alerts...

Read more »

How to Batch Set the Error Log Location for Multiple SQL Server Agents

If you are given a task of changing the SQL Server agent's Error log location for a single SQL Server instance, you could easily do that by using SQL Server management studio. However, if the same task must be completed for almost 1000 SQL instances, you might take a month to complete it. In this article, we will learn how to update SQL Server agent's Error log path through TSQL. For a single instance To set a new location for the SQL Server agent’s error log, using SQL server management...

Read more »