"Benzine" <bfausti@gmail.com> wrote in message
news:1168386601.375776.238150@i56g2000hsf.googlegroups.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
>