I created a copy of the database on the remote server and generated a SQL script to TRUNCATE all the tables in the copy database as shown in Listing 1. After a quick backup of the newly cleaned ...

I'm doing some development on a dev server of ours for a site that's currently live on another server. They have their own server with a SQL Server database holding the data for the live site. So ...

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 ...