Scott Stephens creates a package that allows you to clone most database objects with dynamic SQL.

Figure 6. We have really just dipped our toe into the water that is using SMO with PowerShell to explore and report on various portions of SQL server and its database and tables. We can also do things ...

The wizard can be found by right clicking the database they want to copy in SQL Server Management Studio and selecting Tasks and then Copy Database from the menu. Before-and-After Upgrade Checklist ...

Learn how Data Transformation Services (DTS) can help you import, export, and/or transform data from various sources to single or multiple locations in Microsoft SQL Server 2000.

IntelliSense in SQL Server 2008 works largely as it does in VS, providing you with a list of objects and methods as you type code. The second-most-coveted new feature in Management Studio is T-SQL ...