Thanks to all for the ideas.  Bert De Haes' answer worked for me.

Thanks to all for the replys.  I've got it.

-Malcolm

Works nicely now, thanks.

Thanks for the input.

Example of restore SQL.

Here is an example of the SQL that I figured out to do this. The new db is an exact copy of the old including users...

Thanks to all for the help. I will try both approaches to see which will satisfy my requirements best.

I don't think DTS will let me copy to the same server, unless I am missing something.

quote:

---

hmmm DTS - one way

John Zacharkan

---