sp_attach_single_file_db will work if he has a copy of the detached database, but all he has is a backup file.  Thus my previous suggestion that he ask for a copy...

Paul,

Thanks for the details.  I still think you could do this without DTS.  You can create a job with the first step executing the "kill" stored procedure and the second...

Not sure why you'd want to do this in DTS, but you can execute a stored procedure from DTS by using an Execute SQL task.  Since you posted this in...

See also DTSBackup 2000 at sqldts.com, which can use either DTS as mentioned by Steven or the DTS object model controlled by a GUI.

Greg

No kidding?!  I tried using the arguments also and it does work.  Who knew that was right under our noses

all this time? 

Thanks!

Greg

Yeah, partial restore only works if the database has multiple filegroups.  You can restore part of a database by only restoring certain filegroups.

I'm pretty sure that you can't restore a...

Nali,

Your syntax is wrong.  Use decimal(11,4).

Greg

Neither of the scripts will help unless the package name is used in the job step name.  The original question was how to decrypt an encrypted DTSRUN command and the...

BTW Pinky, you CAN use dtsrunui to get the DTSRUN command either encrypted or not.  It's particularly useful if you're adding a package run step to an existing job.

Greg

The Transform Data task only moves data.  Use the Copy SQL Server Objects task to copy tables and all their attributes.  Alternatively, you can create the tables in the destination...

I've used DTS Backup2000 also, but I haven't been able to copy a package to a new name.

Greg

Well put, Colin.  I just noticed another thread in this forum from someone who, apparently, needed answers to a school assignment that he didn't have time to look up himself.

The only way I can think to change a lot of package names at once, and I'm not sure I'd want to try it,  is to update the name column...

Take a look at "replication, select a type" in BooksOnLine, if you haven't already.  It describes the best use of each type of replication.

Greg

Maintenance plans execute DBCC commands including DBCC CHECKDB to check database integrity and DBCC SHRINKDATABASE to shrink the database files and free up space.  As far as I know, they...