I'm trying to copy a database from one server (SQL Server 2000 Enterprise Edition) to another (SQL Server 2005 Standard Edition) to make sure the second is suitable as a backend to some terrifying ...

Russell Smith is a technology consultant and trainer specializing in management and security of Microsoft server and client technologies. He is a Microsoft Certified Systems Engineer with more than 15 ...

Much of a SQL server's configuration is held in master/model/msdb, so it isn't exactly easy to replace (restoring the master database is a pain, for example).

SQL Servers allow the import or export of database diagrams to another database. All the information related to a database is stored in the dtproperties table. Therefore, to import or export a ...

I needed to copy the SQL Server database, with its most recent schema changes, down to my laptop for a client demonstration at a location where Internet connectivity might not be available. Even ...