I had hoped that it was simply something in the wizard I was overlooking - I guess not!

I haven't tried to use DTS from enterprise manager to move this data...

Maybe this will help.

http://www.intorel.com/Products/ActiveSiteCompiler/whatsnew.asp

I have used Version 2 and 3 of this product over the last few years and it works brilliantly. That said, I was using an...

Hi Greg,

I use Copy SQL Server Objects and Data option in DTS.

I never tick Include all dependent objects because some of the dependant objects don't want to be copied across...

Ok, I guess it must be an anomily in this database!

No problem for now.

Many thanks for your quick replies!

Cheers!

Thanks for the post.

I'll probably go down the route of scripting them at some point then. It's a shame DTS didn't have a checking engine built into it to see...