How do I know if I need SQL SP3 or 3A?

My verions of SQL is 8.00194 (RTM) Does this mean I am current. How would I
go about finding our if I need a service pack installed or not?
MandyH
You're not current. I personally would install the latest service pack
(SP3A).
Your SQL Server is currently open to security risks which, along with
patches, the service pack addresses.
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH
|||Please review the ProductLevel option of the serverproperty() function.
You'll find more details in Books Online...
this will tell you what service pack you have. RTM means released to
manufacturing and means it's the initial release of SQL 2000 with no service
packs. You are currently exposed to a LARGE number of security and other
problems.
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> My verions of SQL is 8.00194 (RTM) Does this mean I am current. How
would I
> go about finding our if I need a service pack installed or not?
> --
> MandyH
|||Okay, thanks very much
"Brian Moran" wrote:

> Please review the ProductLevel option of the serverproperty() function.
> You'll find more details in Books Online...
> this will tell you what service pack you have. RTM means released to
> manufacturing and means it's the initial release of SQL 2000 with no service
> packs. You are currently exposed to a LARGE number of security and other
> problems.
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> would I
>
>
|||Okay. Thanks very much
"Armando Prato" wrote:

> You're not current. I personally would install the latest service pack
> (SP3A).
> Your SQL Server is currently open to security risks which, along with
> patches, the service pack addresses.
>
> "MandyHancock" <MandyHancock@.discussions.microsoft.com> wrote in message
> news:D1314878-A73E-4926-8A9A-93E808C06A05@.microsoft.com...
> would I
>
>