!!! How to find installed Hotfixes on SQL servers

From: Aleem A Mohammed (aleem.mohammed@datastructures.com)
Date: 09/24/02

Next message: Aleem A Mohammed: "How to execute script.sql from VB6"
Previous message: Aleem A Mohammed: "What's the fastest way to assign read/write/execute right to a user?"
In reply to: MP: "!!! How to find installed Hotfixes on SQL servers"
Next in thread: Hal Berenson: "Re: !!! How to find installed Hotfixes on SQL servers"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

From: "Aleem A Mohammed" <aleem.mohammed@datastructures.com>
Date: Tue, 24 Sep 2002 13:34:15 -0700

Use Master
Go
Select @@Version
go

If Version is..... 8.0.194 (No service Pack)
if Version is...... 8.8.534 (SP2)
If Version is with Security Update then 8.0.655

If this will help you.

Aleem A Mohammed

>-----Original Message-----
>How to find hotfixes installed on SQL servers.
>.
>

Next message: Aleem A Mohammed: "How to execute script.sql from VB6"
Previous message: Aleem A Mohammed: "What's the fastest way to assign read/write/execute right to a user?"
In reply to: MP: "!!! How to find installed Hotfixes on SQL servers"
Next in thread: Hal Berenson: "Re: !!! How to find installed Hotfixes on SQL servers"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Relevant Pages

RE: 2003 SP2 to 2003 SP2 R2 on a forest root DC
... SP2 obviously), mainly for the FRS Replication feature. ... Domain Naming Master ... Add components of R2 as needed using Add/Remove Windows components ... Any issues with this plan? ...
(microsoft.public.windows.server.active_directory)
RE: I can not update Office 2000 why?
... You Cannot Update Office to SP2 Without Installing the Outlook ... the Outlook Security Update is automatically applied. ... following Microsoft Web site and refer to the Microsoft Office Resource ...
(microsoft.public.office.setup)
Re: Project color dot
... and I did not apply SP2 yet ... it seems to be caused by Apple's security update, ... >> Why have all my e-mails and calendar events all of a sudden lost their color ... >> the correct project is ticked, and e-mails and events show up correctly in ...
(microsoft.public.mac.office.entourage)
Re: Project color dot
... it seems to be caused by Apple's security update, ... >> update before you'll see the dots again, ... that system and launched by SP2 updated copy of Entourage. ... Apple: PLEASE FIX THIS!!!!!!! ...
(microsoft.public.mac.office.entourage)
Re: Installing cumulative update for OE 6
... Rolling back SP2 doesn't sound like something I want to be doing.... ... > attempt to download and install 887797, ... >> Security Update for Windows XP ... >> Cumulative Security Update for Internet Explorer for Windows XP Service ...
(microsoft.public.windows.inetexplorer.ie6_outlookexpress)