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 »

How to Auto Move All Recipients except Original Sender to “CC” Field When Using “Reply All” in Outlook

Some users always move all the recipients except the original sender to “CC” field when using “Reply All” in Outlook. This article will introduce a method to automate the movement with Outlook VBA. By default, when you select “Reply All” to reply an email, all the recipients who was originally in “To” field will be still placed in the “To” field in the replying mail. However, many users would like to move all the recipients to the “CC” field with only the original...

Read more »

5 Quick Methods to Batch Delete Multiple Rows or Columns in Your Word Table

In this article, we would like to show you 5 quick methods to batch delete multiple rows or columns in your Word table. We put data into tables to make document easy to the eye. It’s not uncommon to create a long table. However, when you check the table again and find some rows and columns unnecessary, you will need a quick way to remove them. First let’s look at ways to delete multiple consecutive rows or columns. Method 1: Delete Rows or Columns through Contextual Menu ...

Read more »