Detaching CDC

Detach & Attach Procedure

For successful run, Your SQL Server service account should have permission to old location & new location

Get Detach or Attach all user databases script

Script to generate script to detach or attach user databases

Create Database

Attach Database

This script will generate scripts to create each database on a sever for attach.

RE: No Rights to Trade Secrets

Of course the media wants him gone!  News published by consumers for consumers directly threatens the centralized (hierarchal) model the media depends on to make a profit.  Now is not the place to debate whether the US media is "White House friendly" or not, but I'm sure that's not the issue.Anybody read "Snowcrash"?  Remember the […]

RE: Fill factor best practices

Thanks for the correction, Hans. I never knew there was a difference. Have to extend my reading material.

RE: Bulk Insert

You should also check TempDB as it will be growing to support the indexes during the inserts.Steve Hughes, Magenic Technologiessteve.hughes@magenic.com

RE: running a dts package from access project

You can also use VBA and ADO to execute a stored procedure that calls the DTS package. Here's an example of a stored procedure that uses the system stored procedure xp_cmdshell and the dtsrun.exe command to execute the package: CREATE PROC ap_CallDTS AS SET NOCOUNT ON DECLARE @cmd varchar(255) DECLARE @error int --command string SET […]

RE: Archiving Changed Data

Some thoughts and questions on this subject. I've done something similar. I've also added a DELETE trigger, to mark in the audit log when and if the data got deleted, which has proven very useful on occasion. There would seem to be two tactics to this: either write the data to the log as it […]