Open SQL Server Management Studio and click New Query. 2. ... If you anwered yes, did you know that you also have to change the name in SQL Server? Here are the steps to perform the change. 1.

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. ... For example, to change the name of the Execute SQL task, click on the value beside the "Name" label, ...

Change Data Capture in SQL Server 2008. Analysis. Oct 16, 2008 3 mins. ... If you need to know the column data involved in an insert, update or delete statement then CDC is for you.