Conflicting SQL Version Info

Hi,
I am managing an instance of SQL server which is running replication, I
am not sure what SP is running on this version as I am getting
conflicting information when I run "Print @.@.Version", the following is
the result:
"Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"
The version number tells me it is SP4 but the last line "Build 3790:
Service Pack 1" tells me otherwise.
Has anyone come across this before? I tried running the SP4 upgrade but
got an error during installation, something about replication.
Also the subscribers are running the desktop engine version of SQL and
have a different version than the main server. When I run "Print
@.@.Version" I get:
"Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)"
Will this cause me issues? Should I upgrade the subscribers to SP4 as
well?
Please help.
Ben
the last line refers to the version of the os. The first one is SQL 2000 sp
4 running on win2003 sp 1. The second is SQL 2000 RTM, running on Windows xp
sp2.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Benzine" <bfausti@.gmail.com> wrote in message
news:1168386601.375776.238150@.i56g2000hsf.googlegr oups.com...
> Hi,
> I am managing an instance of SQL server which is running replication, I
> am not sure what SP is running on this version as I am getting
> conflicting information when I run "Print @.@.Version", the following is
> the result:
> "Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
> May 3 2005 23:18:38
> Copyright (c) 1988-2003 Microsoft Corporation
> Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 1)"
> The version number tells me it is SP4 but the last line "Build 3790:
> Service Pack 1" tells me otherwise.
> Has anyone come across this before? I tried running the SP4 upgrade but
> got an error during installation, something about replication.
> Also the subscribers are running the desktop engine version of SQL and
> have a different version than the main server. When I run "Print
> @.@.Version" I get:
> "Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
> Dec 17 2002 14:22:05
> Copyright (c) 1988-2003 Microsoft Corporation
> Desktop Engine on Windows NT 5.1 (Build 2600: Service Pack 2)"
> Will this cause me issues? Should I upgrade the subscribers to SP4 as
> well?
> Please help.
> Ben
>