Could some please give me some pointers on what I am doing wrong?
Thank you
GarryHi
if your Goal is to change the DB collation I think you can use the DMO to do so, I faced this problem before and I used the Collation property of the Database2 object of the DMO and it worked with some errors that needs fix .
you may loop on your all varchar/char field (using the DMO also) to change their collations in order to fit the new collation of the DB.
It worked with me and I think it is better that using DTS
I suggest you Backup before |||Hi Garry,
Change your primary DB collations first using sql statment change dbcollations 'collation name'
No comments:
Post a Comment