how do i know which SP am I working on?

How do I know which service pack of SQL 2000, am I working on?
Is there any 'select' for this?
Pls help.
regards
KP
http://support.microsoft.com/default...b;en-us;321185
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> How do I know which service pack of SQL 2000, am I working on?
> Is there any 'select' for this?
> Pls help.
> regards
> KP
|||select serverproperty('ProductLevel')
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> How do I know which service pack of SQL 2000, am I working on?
> Is there any 'select' for this?
> Pls help.
> regards
> KP
|||hi jasper,
thanx for quick response. it works.
now tell me, if i know that i'm working on SP4 now, is there any way to
downgrade to SP3? There are a lot of issues experienced in SP4 ...
regards
KP
"Jasper Smith" wrote:

> select serverproperty('ProductLevel')
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
> wrote in message news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
>
>
|||Read the readme:
To revert to a pre-SP4 version of SQL Server
1.. Detach all user databases. For more information, see "How to attach
and detach a database (Enterprise Manager)" in SQL Server Books Online.
2.. Uninstall SQL Server. In Control Panel, double-click Add/Remove
Programs, select the instance of SQL Server that you want to uninstall, and
click Remove.
3.. Reinstall SQL Server 2000 from the CD-ROM or from the location where
you originally installed SQL Server.
4.. Apply any service packs and hotfixes that were installed before
Database Components SP4.
5.. Restore the databases master, msdb, and model from the last backup
that was created before you installed. If the location of the data files has
not changed, this restoration automatically attaches any user databases that
were attached at the time the backup was created.
6.. Attach any user databases that were created after the last backup of
the master database.
7.. Configure replication if necessary.
Warning When you revert to the pre-SP4 version of SQL Server 2000, all
changes made to the databases master, msdb, and model since applying SP4 are
lost.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...[vbcol=seagreen]
> hi jasper,
> thanx for quick response. it works.
> now tell me, if i know that i'm working on SP4 now, is there any way to
> downgrade to SP3? There are a lot of issues experienced in SP4 ...
> regards
> KP
> "Jasper Smith" wrote:
|||Also if you're having issues with SP4 then do contact PSS to open a support
case
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...[vbcol=seagreen]
> hi jasper,
> thanx for quick response. it works.
> now tell me, if i know that i'm working on SP4 now, is there any way to
> downgrade to SP3? There are a lot of issues experienced in SP4 ...
> regards
> KP
> "Jasper Smith" wrote:
|||what kind of issues are seen here?is there any known issue in SP4 that it's
not recommended to be installed?
"Jasper Smith" wrote:

> Also if you're having issues with SP4 then do contact PSS to open a support
> case
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
> wrote in message news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...
>
>

how do i know which SP am I working on?

How do I know which service pack of SQL 2000, am I working on?
Is there any 'select' for this?
Pls help.
regards
KPhttp://support.microsoft.com/default.aspx?scid=kb;en-us;321185
--
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> How do I know which service pack of SQL 2000, am I working on?
> Is there any 'select' for this?
> Pls help.
> regards
> KP|||select serverproperty('ProductLevel')
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> How do I know which service pack of SQL 2000, am I working on?
> Is there any 'select' for this?
> Pls help.
> regards
> KP|||hi jasper,
thanx for quick response. it works.
now tell me, if i know that i'm working on SP4 now, is there any way to
downgrade to SP3? There are a lot of issues experienced in SP4 ...
regards
KP
"Jasper Smith" wrote:
> select serverproperty('ProductLevel')
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
> wrote in message news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> > How do I know which service pack of SQL 2000, am I working on?
> > Is there any 'select' for this?
> >
> > Pls help.
> >
> > regards
> > KP
>
>|||Read the readme:
To revert to a pre-SP4 version of SQL Server
1.. Detach all user databases. For more information, see "How to attach
and detach a database (Enterprise Manager)" in SQL Server Books Online.
2.. Uninstall SQL Server. In Control Panel, double-click Add/Remove
Programs, select the instance of SQL Server that you want to uninstall, and
click Remove.
3.. Reinstall SQL Server 2000 from the CD-ROM or from the location where
you originally installed SQL Server.
4.. Apply any service packs and hotfixes that were installed before
Database Components SP4.
5.. Restore the databases master, msdb, and model from the last backup
that was created before you installed. If the location of the data files has
not changed, this restoration automatically attaches any user databases that
were attached at the time the backup was created.
6.. Attach any user databases that were created after the last backup of
the master database.
7.. Configure replication if necessary.
Warning When you revert to the pre-SP4 version of SQL Server 2000, all
changes made to the databases master, msdb, and model since applying SP4 are
lost.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...
> hi jasper,
> thanx for quick response. it works.
> now tell me, if i know that i'm working on SP4 now, is there any way to
> downgrade to SP3? There are a lot of issues experienced in SP4 ...
> regards
> KP
> "Jasper Smith" wrote:
>> select serverproperty('ProductLevel')
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Krishnaprasad Paralikar"
>> <KrishnaprasadParalikar@.discussions.microsoft.com>
>> wrote in message
>> news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
>> > How do I know which service pack of SQL 2000, am I working on?
>> > Is there any 'select' for this?
>> >
>> > Pls help.
>> >
>> > regards
>> > KP
>>|||Also if you're having issues with SP4 then do contact PSS to open a support
case
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...
> hi jasper,
> thanx for quick response. it works.
> now tell me, if i know that i'm working on SP4 now, is there any way to
> downgrade to SP3? There are a lot of issues experienced in SP4 ...
> regards
> KP
> "Jasper Smith" wrote:
>> select serverproperty('ProductLevel')
>> --
>> HTH
>> Jasper Smith (SQL Server MVP)
>> http://www.sqldbatips.com
>> I support PASS - the definitive, global
>> community for SQL Server professionals -
>> http://www.sqlpass.org
>> "Krishnaprasad Paralikar"
>> <KrishnaprasadParalikar@.discussions.microsoft.com>
>> wrote in message
>> news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
>> > How do I know which service pack of SQL 2000, am I working on?
>> > Is there any 'select' for this?
>> >
>> > Pls help.
>> >
>> > regards
>> > KP
>>|||what kind of issues are seen here?is there any known issue in SP4 that it's
not recommended to be installed?
"Jasper Smith" wrote:
> Also if you're having issues with SP4 then do contact PSS to open a support
> case
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
> wrote in message news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...
> > hi jasper,
> > thanx for quick response. it works.
> > now tell me, if i know that i'm working on SP4 now, is there any way to
> > downgrade to SP3? There are a lot of issues experienced in SP4 ...
> >
> > regards
> > KP
> >
> > "Jasper Smith" wrote:
> >
> >> select serverproperty('ProductLevel')
> >>
> >> --
> >> HTH
> >>
> >> Jasper Smith (SQL Server MVP)
> >> http://www.sqldbatips.com
> >> I support PASS - the definitive, global
> >> community for SQL Server professionals -
> >> http://www.sqlpass.org
> >>
> >> "Krishnaprasad Paralikar"
> >> <KrishnaprasadParalikar@.discussions.microsoft.com>
> >> wrote in message
> >> news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> >> > How do I know which service pack of SQL 2000, am I working on?
> >> > Is there any 'select' for this?
> >> >
> >> > Pls help.
> >> >
> >> > regards
> >> > KP
> >>
> >>
> >>
>
>sql

how do i know which SP am I working on?

How do I know which service pack of SQL 2000, am I working on?
Is there any 'select' for this?
Pls help.
regards
KPhttp://support.microsoft.com/defaul...kb;en-us;321185
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> How do I know which service pack of SQL 2000, am I working on?
> Is there any 'select' for this?
> Pls help.
> regards
> KP|||select serverproperty('ProductLevel')
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com...
> How do I know which service pack of SQL 2000, am I working on?
> Is there any 'select' for this?
> Pls help.
> regards
> KP|||hi jasper,
thanx for quick response. it works.
now tell me, if i know that i'm working on SP4 now, is there any way to
downgrade to SP3? There are a lot of issues experienced in SP4 ...
regards
KP
"Jasper Smith" wrote:

> select serverproperty('ProductLevel')
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.co
m>
> wrote in message news:96D7A601-8C86-4844-A8F7-256DDB987397@.microsoft.com..
.
>
>|||Read the readme:
To revert to a pre-SP4 version of SQL Server
1.. Detach all user databases. For more information, see "How to attach
and detach a database (Enterprise Manager)" in SQL Server Books Online.
2.. Uninstall SQL Server. In Control Panel, double-click Add/Remove
Programs, select the instance of SQL Server that you want to uninstall, and
click Remove.
3.. Reinstall SQL Server 2000 from the CD-ROM or from the location where
you originally installed SQL Server.
4.. Apply any service packs and hotfixes that were installed before
Database Components SP4.
5.. Restore the databases master, msdb, and model from the last backup
that was created before you installed. If the location of the data files has
not changed, this restoration automatically attaches any user databases that
were attached at the time the backup was created.
6.. Attach any user databases that were created after the last backup of
the master database.
7.. Configure replication if necessary.
Warning When you revert to the pre-SP4 version of SQL Server 2000, all
changes made to the databases master, msdb, and model since applying SP4 are
lost.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
schrieb im Newsbeitrag
news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...[vbcol=seagreen]
> hi jasper,
> thanx for quick response. it works.
> now tell me, if i know that i'm working on SP4 now, is there any way to
> downgrade to SP3? There are a lot of issues experienced in SP4 ...
> regards
> KP
> "Jasper Smith" wrote:
>|||Also if you're having issues with SP4 then do contact PSS to open a support
case
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.com>
wrote in message news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com...[vbcol=seagreen]
> hi jasper,
> thanx for quick response. it works.
> now tell me, if i know that i'm working on SP4 now, is there any way to
> downgrade to SP3? There are a lot of issues experienced in SP4 ...
> regards
> KP
> "Jasper Smith" wrote:
>|||what kind of issues are seen here?is there any known issue in SP4 that it's
not recommended to be installed?
"Jasper Smith" wrote:

> Also if you're having issues with SP4 then do contact PSS to open a suppor
t
> case
> --
> HTH
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
> "Krishnaprasad Paralikar" <KrishnaprasadParalikar@.discussions.microsoft.co
m>
> wrote in message news:CD3FF987-647B-4642-A95E-A1968D71F100@.microsoft.com..
.
>
>

How do I know when a patch is available for SQL Server?

I installed Service Pack a3. It seems that Windows Automatic Updates is not
able to catch any patch(not sp) for SQL Server. Is there anyway that I can
make the patching automatic(at least notify me when a patch for SQL Server is
available)?
Thanks in advance!
Bo Sun
I am sure that you don't want the SP auto patched you SQL server!
Sign up with http://www.microsoft.com/security/default.mspx for email
update.
"Bo Sun" <Bo Sun@.discussions.microsoft.com> wrote in message
news:234E0FB7-91CC-4103-9BEF-6F9D067BB44E@.microsoft.com...
>I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server
> is
> available)?
> Thanks in advance!
> Bo Sun
|||> I installed Service Pack a3. It seems that Windows Automatic Updates is
not
> able to catch any patch(not sp) for SQL Server.
This is because most post-SP3a updates are hotfixes for specific
bugs/problems, not security patches (and are not relevant for all users).
You can stay pretty much on top of new hotfixes here:
http://www.aspfaq.com/2160 ...
Remember, also, that windows update is for windows, not SQL Server. I
believe they are planning similar functionality for SQL Server 2005, but
don't hold me to that.
http://www.aspfaq.com/
(Reverse address to reply.)
|||Hi
Patching SQL Server is currently not possible with Windows Update. This may
change in the future.
Regards
Mike
"Bo Sun" wrote:

> I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server is
> available)?
> Thanks in advance!
> Bo Sun

How do I know when a patch is available for SQL Server?

I installed Service Pack a3. It seems that Windows Automatic Updates is not
able to catch any patch(not sp) for SQL Server. Is there anyway that I can
make the patching automatic(at least notify me when a patch for SQL Server is
available)?
Thanks in advance!
Bo SunI am sure that you don't want the SP auto patched you SQL server!
Sign up with http://www.microsoft.com/security/default.mspx for email
update.
"Bo Sun" <Bo Sun@.discussions.microsoft.com> wrote in message
news:234E0FB7-91CC-4103-9BEF-6F9D067BB44E@.microsoft.com...
>I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server
> is
> available)?
> Thanks in advance!
> Bo Sun|||> I installed Service Pack a3. It seems that Windows Automatic Updates is
not
> able to catch any patch(not sp) for SQL Server.
This is because most post-SP3a updates are hotfixes for specific
bugs/problems, not security patches (and are not relevant for all users).
You can stay pretty much on top of new hotfixes here:
http://www.aspfaq.com/2160 ...
Remember, also, that windows update is for windows, not SQL Server. I
believe they are planning similar functionality for SQL Server 2005, but
don't hold me to that.
--
http://www.aspfaq.com/
(Reverse address to reply.)|||Hi
Patching SQL Server is currently not possible with Windows Update. This may
change in the future.
Regards
Mike
"Bo Sun" wrote:
> I installed Service Pack a3. It seems that Windows Automatic Updates is not
> able to catch any patch(not sp) for SQL Server. Is there anyway that I can
> make the patching automatic(at least notify me when a patch for SQL Server is
> available)?
> Thanks in advance!
> Bo Sun

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?
--
MandyHYou'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 servi
ce
> 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
>
>

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
>
>

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?
--
MandyHYou'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...
> > 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
"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...
> > 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
>
>

How do I do an Unattended install of "MSDE 1.0 sp4"?

I am trying to upgrade an MSDE 1.0 db with the Service Pack 4 patch

but I need to do either a Silent or Unattended install.

Does anyone know how to do this? Does anyone know the

command-line command to do this?

I tried using...

sql70sp4.exe -a -f1 "unattend.iss"

....but that didn't work. It popped up a window asking where I

should extract the contents of the .exe (that shouldn't be appearing

either) and then after it extracted it didn't do anything else.

Any help is greatly appreciated.

see if this helps

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q233312