Thanks,
Howie
----- Original Message -----
From: Bryan Stevenson
To: CF-Talk
Sent: Thursday, August 19, 2004 12:36 PM
Subject: Re: Copying an MSSQL 2000 database
rough idea here...I'm no DTS pro ;-)
-fire off a SP to create a new EMPTY DB for the new user
-fire off DTS to import the blank tables from your dummy DB into the newly created DB for the user
I would think the SP to create an empty DB would be failry straight forward....not sure how you fire off DTS to do the import...but I'm sure I've seen that question asked and answerd on this list a few times.
HTH
Cheers
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
phone: 250.480.0642
fax: 250.480.1264
cell: 250.920.8830
e-mail: [EMAIL PROTECTED]
web: www.electricedgesystems.com
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
