dbTalk Databases Forums  

Re: change style comparison for user DB

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss Re: change style comparison for user DB in the microsoft.public.sqlserver.server forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Tibor Karaszi
 
Posts: n/a

Default Re: change style comparison for user DB - 10-15-2003 , 01:52 AM






Quote:
it is possible change style comparison from a backup?
No.

--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver


"vladimir" <vladimir.gutierrez (AT) molymet (DOT) cl> wrote

Quote:
because original server was reinstalled and have no choice
to mount this databases due to error.
it is possible change style comparison from a backup? , i
have an off-line data file copy too. can i do something?.

Rgds.

-----Original Message-----
If the servers can see each other why not transfer all
objects using DTS to
circumvent this problem

--
HTH
Ryan Waight, MCDBA, MCSE

"vladimir" <vladimir.gutierrez (AT) molymet (DOT) cl> wrote in
message
news:2a7d901c39262$547a0900$a601280a (AT) phx (DOT) gbl...
Hi,

I have 2 SQL Server 7.0 and they are similar except
for style comparison. I reinstall one server and when
try
to attach users db to new server from a backup, an error
occurs like this "style comparison for DB XXXX
are '196609' and server uses '196611'".

Anybody know that how can i do to change style
comparison
for DB without affecting master db? can i do this?

tks.
DBA Beginner.



.




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.