Thanks for your suggestions. DTS was giving me failures on copying some of the objects.... This db has multiple file groups, anyway, never made it past the failure. (and it said copy files and data where I only wanted files). There are multiple file groups, which may be an issue in itself?

The db is too big to do anything with as far as moving, copying etc. And we don't have enough extra space on ANY server! 17 gig db with only a few gig available at the best of times on the current db server. I know.... not the best situation, but it's why we are moving to a new 64 bit server.

I will try the scripting method, it might take all day to get a script but it's likely my only option. Then do I have to fix the logins for sql 2005?

Thanks again in advance for your help. If we were given the appropriate disk space none of this would really be an issue at all! 🙂