Re: Newbie Question - what version of SQL am I running

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks

"Hugo Kornelis" <hugo@xxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:d18le1lanp0p3i4616tic913nb91u69hpk@xxxxxxxxxx
> On Thu, 28 Jul 2005 18:42:05 -0700, boe wrote:
>
>>Wow - thanks - that is a hell of a lot of work - you'd think they'd have a
>>help about but Exchange still says version 6.5 or some such thing for
>>2003 -
>>what the heck is it with MS and burying the versions of the software - why
>>not give them in Hex so it is even harder to figure out?
>
> Hi boe,
>
> It's not as bad as you think it is. In Query Analyzer, you can use the
> menu item "Help" / "About" to get the version. Enterprise Manager is
> slightly different, becuase it runs as an embedded application in the
> Windows Management Console - to get the version of EM, you need to
> right-click "Microsoft SQL Servers", then select "About SQL Server
> Enterprise Manager".
>
> However, both the above options will inform you of the current version
> of the client tools on your computer. There is no guarantee that the
> server you connect to is running the same version - it might have a more
> recent service pack or a hot-fix, or it might even be another version!
> That's why the only way to find the version of the SERVER is to connect
> to the server and ask - SELECT @@VERSION does just that.
>
> Best, Hugo
> --
>
> (Remove _NO_ and _SPAM_ to get my e-mail address)


.

Relevant Pages

  • Re: Newbie Question - what version of SQL am I running
    ... >what the heck is it with MS and burying the versions of the software - why ... >not give them in Hex so it is even harder to figure out? ... Windows Management Console - to get the version of EM, ... That's why the only way to find the version of the SERVER is to connect ...
    (microsoft.public.sqlserver.setup)
  • Re: SBS2003 New instralaltion onto a Dell POweredge 2900
    ... I installed the 948496 patch first, reset the server and the remote desktop ... Server administrator, and navigate to `virtual disk`, there set cache to ... this has been one of the worst installs I have ever had in a long time. ... and I have to say I'm frustrated in what the heck is ...
    (microsoft.public.windows.server.sbs)
  • Eval Errors
    ... I'm passing a server I wrote some Perl code I want it to eval. ... but it's generating some warnings on the server, ... That slew of errors is complaining about the code I passed eval. ... How the heck is shutting off ...
    (perl.beginners)
  • Re: I just want a decent server!
    ... I'm having a heck of a time trying to find somewhere ... responsible and responsive to buy a server from. ... size hot swap drives), CD/floppy INTERNAL this time, I need a SCSI ...
    (freebsd-isp)
  • I just want a decent server!
    ... I'm having a heck of a time trying to find somewhere ... responsible and responsive to buy a server from. ... size hot swap drives), CD/floppy INTERNAL this time, I need a SCSI ...
    (freebsd-isp)