Learn More. Microsoft Corp.s long-awaited SQL Server 2005 represents significant change for administrators—the database server includes several new features that add capability and improve ...

Ok, for SQL server 2000, I need to change the account it runs under. <BR><BR>I know you need to go to the Enterprise Manager, find the database, right click, properties, choose security tab ...

You can use Execute SQL tasks to create, alter and drop database objects, as well as to prepare and truncate data and to return result sets. You can also combine tasks with iterative code ...

Restriction: You cannot use any type of view in an ALTER TABLE statement. Restriction: You cannot use ALTER TABLE on a table that is accessed via an engine that does not support UPDATE processing.

One of the interesting new features in SQL Server 2008 is Change Data Capture. I wrote about Change Tracking in a previous blog entry. That will track the what, when and who but will not tell you ...