eliechucrallah@hotmail.com

i was trying to register a new server in enterprise manager i got the
following message : "the client and server codepages do not match. some
ansi character mappings may not be possible" but under sql server
properties,general tab i have the same code page, just different product
version because of the installed service pack. i've used other then the
default collation and i am using replication between these two server.
the application is working fine not sure if the replication will work
fine. maybe other other settings in the same page where i choose
collation during setup don't match how can i check these settings after
setup is done ? i am using sql 7
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
elie,
What service pack levels are you running on the client and the server?
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> i was trying to register a new server in enterprise manager i got the
> following message : "the client and server codepages do not match. some
> ansi character mappings may not be possible" but under sql server
> properties,general tab i have the same code page, just different product
> version because of the installed service pack. i've used other then the
> default collation and i am using replication between these two server.
> the application is working fine not sure if the replication will work
> fine. maybe other other settings in the same page where i choose
> collation during setup don't match how can i check these settings after
> setup is done ? i am using sql 7
>
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
|||select @.@.version
gave me this
Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
Nov 27 1998 22:20:07
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
on 1 server and this
Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
on the other
and sp_helpsort gave me the same result on both servers
i just downloaded sql 7 sp4 should i install it ?
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
|||elie,
You should install SP4 on both machines.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
elie chucrallah wrote:
> select @.@.version
> gave me this
> Microsoft SQL Server 7.00 - 7.00.623 (Intel X86)
> Nov 27 1998 22:20:07
> Copyright (c) 1988-1998 Microsoft Corporation
> Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
> on 1 server and this
> Microsoft SQL Server 7.00 - 7.00.842 (Intel X86)
> Mar 2 2000 06:49:37
> Copyright (c) 1988-1998 Microsoft Corporation
> Desktop Edition on Windows NT 5.0 (Build 2195: Service Pack 2)
> on the other
> and sp_helpsort gave me the same result on both servers
> i just downloaded sql 7 sp4 should i install it ?
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>
>