full article :
http://support.microsoft.com/kb/321185 How to determine which version of SQL Server 2005 is running
To determine which version of Microsoft SQL Server 2005 is running, connect
to SQL Server 2005 by using SQL Server Management Studio, and then run the
following Transact-SQL statement:
SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')The results are: . The product version (for
example, "9.00.1399.06").
. The product level (for example, "RTM").
. The edition (for example, "Enterprise Edition").
For example, the result looks similar to: 9.00.1399.06 RTM Enterprise
Edition
The following table lists the Sqlservr.exe version number: Release
Sqlservr.exe
RTM 2005.90.1399
SQL Server 2005 Service Pack 1 2005.90.2047
HTH,
_Edwin.
[quoted text, click to view] "Padraig" <Padraig@discussions.microsoft.com> wrote in message
news:C22D2253-E8C3-470C-A2FC-AEE5926C803A@microsoft.com...
> Sorry Edwin,
>
> I should have been clearer, it is my SQL 2005 that reports the different
SP
> levels.
>
> My Op system is 2003 SP1 on both nodes.
>
> "Edwin vMierlo" wrote:
>
> > Right-click on "My Computer", choose "Properties"
> > On the "General" tab it should list the OS, version, edition and service
> > pack.
> >
> >
> >
> >
> > "Padraig" <Padraig@discussions.microsoft.com> wrote in message
> > news:CED760FA-B89B-432E-B56E-6EF77BA23915@microsoft.com...
> > > I totally agree.
> > >
> > > I thought I had applied SP1 was on both nodes.
> > > Whats the best way to check for sure that SP1 is on both nodes ?
> > >
> > > "Edwin vMierlo" wrote:
> > >
> > > > Dear Pádraig,
> > > >
> > > > So the questions you need to answer are:
> > > > - is SP1 installed on Node-1 ?
> > > > - is SP1 installed on Node-2 ?
> > > >
> > > > You must be in control of what is installed on your cluster nodes,
both
> > > > Service pack as well as hotfixes and security fixes, if you don't
have
> > an
> > > > administration for this, I strongly suggest you start this. You
cluster
> > must
> > > > be fully documented, that should be part of your HA strategy. To be
> > honest,
> > > > I would not *just* rely on "Windows Update" to manage the service
packs
> > or
> > > > updates on a cluster.
> > > >
> > > > bottom-line, your service pack level MUST be the same on both nodes
> > > >
> > > > rgds,
> > > > Edwin.
> > > >
> > > >
> > > >
> > > > "Padraig" <Padraig@discussions.microsoft.com> wrote in message
> > > > news:91BEA35A-48B6-4AEE-91D3-353CC739F8D7@microsoft.com...
> > > > > Hi Guys,
> > > > >
> > > > > Have a weird one. I was running windows update on my nodes.
> > > > > My passive node reports that it needs SP1
> > > > > My active node doesnt need it .
> > > > >
> > > > > Any ideas.
> > > > >
> > > > > I'm a little worried about this.
> > > >
> > > >
> > > >
> >
> >
> >