I usually xfer or move 7.0 to 7.0 database via import/export objects in EM or via detach/attach database referenced to its physical files. But how can I xfer DB from 6.5 to 7.0 providing that I have db1.dat and db1log.dat from our only 6.5 server which has crashed & need rebuild?
Do I have to have 6.5 installed on my server to load up this DB? Is there any alternative from doing that?
Thanks in advance,
Koann
Hi,
We have to copy data from files from Novell system to Sql sever 2000. I use DTS for that. The problem is that Novell system files(the way they are extracted) has end of file character. Because of this the DTS package fails. But if we open the file, get rid of the end of file character (looks like square in wordpad), the package runs fine.
Is there any way to make DTS identify this character as end of file and ignore it? We have hundreds of files to move on regular basis and some of the files are large (> 10 MB) so that we cannot open it or see it.
Any suggestion will be appreciated.
OK. I screwed-up. SS2005. I gave a user ownership of schema "db_owner" and now I can not change it back to what it was (unknown) so I can delete the user. So how do I change ownership of "db_owner" back to what it was so I can delete the user???
Thanks,
Michael