change style comparison for user DB

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.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@.molymet.cl> wrote in message
news:2a7d901c39262$547a0900$a601280a@.phx.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.
>|||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@.molymet.cl> wrote in
message
>news:2a7d901c39262$547a0900$a601280a@.phx.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.
>
>.
>|||> 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@.molymet.cl> wrote in message
news:0a3d01c3927e$f3b732b0$a001280a@.phx.gbl...
> 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@.molymet.cl> wrote in
> message
> >news:2a7d901c39262$547a0900$a601280a@.phx.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.
> >>
> >
> >
> >.
> >