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.

In the case above, I resorted to using DELETE FROM statements for each table, and suffered the performance penalty. What I would have preferred is the ability to run a SQL script to delete all the ...

How to import or export diagrams with SQL Server? Information about the diagrams is stored in the dtproperties table. Basically to import or export a diagram, you simply need to import or export the ...

Right-click the existing table name in the Database Window of the original database and click Copy. Close the database Window and open your new database. Under Objects, click Tables.