One new feature in SQL Server Management Studio 2008 is the ability to restrict changes that would force a table to be re-created. This is a safety valve which can be turned off, if you choose. Let’s ...

Execute SQL tasks run stored procedures or SQL queries from SSIS packages. A task executes any SQL statements that have been passed to it in sequential order. It provides you with a handy way to store ...