How do I launch an agent job from command line?

What is the easiest way to execute a SQL Agent (2005) job from the command line? I need to make a batch file to execute a reporting service shared schedule job.

Thanks in advance.

Refer to Books Online, Topic: 'DTExec utility'

DTExec.exe is the replacement for SQL 2000's DTSRun.exe.

|||Correct me if i'm wrong, but I think DTExec is just used for SSIS packages? I need to run the entire job. The job was generated by Reporting Services and I need to call it manually. Thanks a lot.|||

You're correct. I mis-interpreted your question.

You can use SQLCmd.exe, combined with a call to sp_startJob.

(If you are using SQL 2000, then use OSQL.exe instead of SQLCmd.)

Refer to Books Online for the complete syntax for either.

|||

Thanks a lot, I couldn't get the stored procedure to work but i just used the code that it mentioned in the Job properties window. The exact code for sqlcmd was: sqlcmd -Q "exec ReportServer.dbo.AddEvent @.EventType ='SharedSchedule', @.EventData='0dd48b88-6c35-4f3c-913e-b5299de948db'"

Thanks much.

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 where my message come from

I have a service broker service and there are multiple clients that can put messages in the queue of that service. How do I check which message comes from which client? There is no field in the queue like message_senderId or something like that.

If all you need is to send back replies, then is not necesary too know the sender of the message. Simply send back replies on the conversation_handle received and they'll reach the sender.

If you need to know for other reasons, look up sys.conversation_endpoints by the conversation_handle of the received message. It contains the far_fervice and far_broker_instance fields, that are the name of the service that sent the message and the service_broker_guid of the database that hosts that service.

HTH,
~ Remus

sql

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 get rid of SQL Server?

An icon for Microsoft SQL Server Service Manager just started showing

up on my taskbar. I didn't install SQL Server. The icon

starting showing up after I ran Windows Update. SQL Server is not

listed in my Add/Remove programs, and I can't seem to find the

application anywhere on my laptop. I have a new (less than 6

months old) Dell laptop running WinXP Professional. I seem to

have lost my Internet connectivity at about the same time this icon

showed up. I did a system restore back to before I installed the

Windows Update, and the icon disappeared. However, it has now

shown up again. Anybody know what's going on with this?

Does some other app use SQL server? I really need to fix this

problem.

Thx,

j

See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005

http://msdn2.microsoft.com/en-us/library/aa337087.aspx

|||

Hi

By reading at your description, I can't really tell what has happen to your machine.

But please try the following:

1. From your desktop, right click on "my computer" icon.

2. Select "manage" from the pop-up menu.

3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.

4. select "Services" node

5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"

If there are any listed, could you please post the list for furthur analysis?

Thank you. :-)

|||

I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.

Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?

Thx,

|||

Hi,

Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.

Hemantgiri S. Goswami

How do I get rid of SQL Server?

An icon for Microsoft SQL Server Service Manager just started showing

up on my taskbar. I didn't install SQL Server. The icon

starting showing up after I ran Windows Update. SQL Server is not

listed in my Add/Remove programs, and I can't seem to find the

application anywhere on my laptop. I have a new (less than 6

months old) Dell laptop running WinXP Professional. I seem to

have lost my Internet connectivity at about the same time this icon

showed up. I did a system restore back to before I installed the

Windows Update, and the icon disappeared. However, it has now

shown up again. Anybody know what's going on with this?

Does some other app use SQL server? I really need to fix this

problem.

Thx,

j

See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005

http://msdn2.microsoft.com/en-us/library/aa337087.aspx

|||

Hi

By reading at your description, I can't really tell what has happen to your machine.

But please try the following:

1. From your desktop, right click on "my computer" icon.

2. Select "manage" from the pop-up menu.

3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.

4. select "Services" node

5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"

If there are any listed, could you please post the list for furthur analysis?

Thank you. :-)

|||

I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.

Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?

Thx,

|||

Hi,

Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.

Hemantgiri S. Goswami

How do I get rid of SQL Server?

An icon for Microsoft SQL Server Service Manager just started showing

up on my taskbar. I didn't install SQL Server. The icon

starting showing up after I ran Windows Update. SQL Server is not

listed in my Add/Remove programs, and I can't seem to find the

application anywhere on my laptop. I have a new (less than 6

months old) Dell laptop running WinXP Professional. I seem to

have lost my Internet connectivity at about the same time this icon

showed up. I did a system restore back to before I installed the

Windows Update, and the icon disappeared. However, it has now

shown up again. Anybody know what's going on with this?

Does some other app use SQL server? I really need to fix this

problem.

Thx,

j

See Books Online -- How to: Manually Uninstall an Existing Instance of SQL Server 2005

http://msdn2.microsoft.com/en-us/library/aa337087.aspx

|||

Hi

By reading at your description, I can't really tell what has happen to your machine.

But please try the following:

1. From your desktop, right click on "my computer" icon.

2. Select "manage" from the pop-up menu.

3. When "Computer Managment" console pop up, expand "Services and Applications" node on left pane.

4. select "Services" node

5. Now look at the right pane on Computer Management console. It lists all the window services that are available on your machine. Please scrow down the list and see if you can find any service name that starts with "SQL Server"

If there are any listed, could you please post the list for furthur analysis?

Thank you. :-)

|||

I'm getting the same message. So I inadvertently (in my jet lag state) removed sqlmanagr.exe from my Add/Remove location. Now my computer is running slowly, does not access the Internet, and my family is ready to disown me.

Pls help - 1) what fixed your problem, and 2) how do I get the service manager back?

Thx,

|||

Hi,

Have you installed Visual Studio on your laptop !!? If yes; SQL Server Express is a part of it. Refer earlier given link for manual un-installation.

Hemantgiri S. Goswami

How do I find out what version of SQL Server 2000 I'm running?

How do I find out what version of SQL Server 2000 I'm running?
The 'about' dialog box on the SQL Server Service Manager
says my version is 8.00.760 but the latest service pack 3
is version 8.00.760.03. I thought I installed this service
pack already.
How can I know for sure?
Thanks
Brad760 is SP3. You have SP3, regardless of the sub-sub-sub-version number.
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad|||Never mind I found out by reading the reply a 8:16 am today.
>--Original Message--
>How do I find out what version of SQL Server 2000 I'm running?
>The 'about' dialog box on the SQL Server Service Manager
>says my version is 8.00.760 but the latest service pack 3
>is version 8.00.760.03. I thought I installed this service
>pack already.
>How can I know for sure?
>Thanks
>Brad
>.
>|||Brad,
The following in the readme file for SP3a. (
http://support.microsoft.com/default.aspx?scid=/support/servicepacks/SQL/2000/SP3ReadMe.asp)
Distinguishing Between SP3 and SP3a
To determine whether you have SP3 or SP3a installed, look at the version
number of the Net-Library file, Ssnetlib.dll. If the version number of this
file is 2000.80.760.0, you have SP3; if the version number of this file is
2000.80.766.0, you have SP3a.
Assuming that an instance was installed using the default settings, you can
find the Ssnetlib.dll file in one of these locations:
a.. Default instance: C:\Program Files\Microsoft
SQLServer\Binn\Ssnetlib.dll
b.. Named instance: C:\Program Files\Microsoft
SQLServer\MSSQL$<InstanceName>\Binn\Ssnetlib.dll
To find out whether you have the SP3 or SP3a setup folders, open the
SP3Readme.htm file and read the first page. The service pack version, SP3a
or SP3, is listed at the top of the first page.
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Brad" <bradfordneal2@.yahoo.com> wrote in message
news:00fe01c351f7$379fb010$a101280a@.phx.gbl...
> How do I find out what version of SQL Server 2000 I'm running?
> The 'about' dialog box on the SQL Server Service Manager
> says my version is 8.00.760 but the latest service pack 3
> is version 8.00.760.03. I thought I installed this service
> pack already.
> How can I know for sure?
> Thanks
> Brad

How do I find out what Service Packs have been installed?

I'm using SQL Server Express on Vista. I can't remember whether or not I installed the service packs for SSEE. Is there a quick and easy way to find out?

hi,

you can query som server properties as (on my running server)

SET NOCOUNT ON; SELECT CONVERT( varchar, SERVERPROPERTY('Edition')) AS Edition , CONVERT( varchar, SERVERPROPERTY('ProductVersion')) AS Version , CONVERT( varchar, SERVERPROPERTY('ProductLevel')) AS Level --< Edition Version Level Express Edition 9.00.3159.00 SP2

regards

How do I downgrade SQL Server from SP4 to SP3?

Hi,

We have hit performance issues with our SQL server after upgraded it to SP3 from SP3a, is there any way that I can downgrade it back to Service Pack3a?

Thanks.

Hi,

refer and follow

http://support.microsoft.com/kb/889551 For removing SP3a

http://sqlserver2000.databases.aspfaq.com/why-am-i-having-problems-with-sql-server-2000-sp3/sp3a.html

http://www.sqlservercentral.com/accessdenied.aspx?SourceURL=/forums/shwmessage.aspx?forumid=5&messageid=123905

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