|
|
Posted by Nasir on 08/22/06 20:49
Is there any easy way to export out all objects and data, so it can be
exported into any collation of SQL server.
Also, if I create multiple users in a databases, that they can have
independent schemas; can they be backed up separately and restores
separately to the same database.
Where did DTS go. It was nice to load or export different formats of data?
TIA
"Nasir" <nmajeed@prosrm.com> wrote in message
news:44e9f86a$0$1005$39cecf19@news.twtelecom.net...
> What is the best way to resolve these collation errors:
>
> My server is installed as - Latin1_General_CS_AS, but one of the
> important 50GB databases migrated from another server has -
> SQL_Latin1_General_CP1_CS_AS, and we are getting errors:
>
> Msg 468, Level 16, State 9, Line 1
> Cannot resolve the collation conflict between "Latin1_General_CS_AS" and
> "SQL_Latin1_General_CP1_CS_AS" in the equal to operation
>
>
>
> WHat sthe best way to resolve these problems...would bcp in/out fix it?
>
>
>
> Tnanks in advance.
>
>
Navigation:
[Reply to this message]
|