Outlook licensing on SQL Server

Hi
Just a quick question, if I use outlook as the MAPI client for the SQL
server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
license for the copy of Outlook I will use on the server even though we wll
not actually be using Outlook on that server as a full client?
I forgot to ask if it also means that we need a, Exhange CAL for the SQL
server as Outlook will be communicating with our Exchange server
"OGTI" wrote:

> Hi
> Just a quick question, if I use outlook as the MAPI client for the SQL
> server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
> license for the copy of Outlook I will use on the server even though we wll
> not actually be using Outlook on that server as a full client?
|||Hi.
You need the appropriate Office license and an Exchange CAL.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"OGTI" <OGTI@.discussions.microsoft.com> wrote in message
news:66B8929F-3E51-4CBD-8707-D03834C372DE@.microsoft.com...[vbcol=seagreen]
>I forgot to ask if it also means that we need a, Exhange CAL for the SQL
> server as Outlook will be communicating with our Exchange server
> "OGTI" wrote:

Outlook licensing on SQL Server

Hi
Just a quick question, if I use outlook as the MAPI client for the SQL
server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
license for the copy of Outlook I will use on the server even though we wll
not actually be using Outlook on that server as a full client?I forgot to ask if it also means that we need a, Exhange CAL for the SQL
server as Outlook will be communicating with our Exchange server
"OGTI" wrote:
> Hi
> Just a quick question, if I use outlook as the MAPI client for the SQL
> server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
> license for the copy of Outlook I will use on the server even though we wll
> not actually be using Outlook on that server as a full client?|||Hi.
You need the appropriate Office license and an Exchange CAL.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"OGTI" <OGTI@.discussions.microsoft.com> wrote in message
news:66B8929F-3E51-4CBD-8707-D03834C372DE@.microsoft.com...
>I forgot to ask if it also means that we need a, Exhange CAL for the SQL
> server as Outlook will be communicating with our Exchange server
> "OGTI" wrote:
>> Hi
>> Just a quick question, if I use outlook as the MAPI client for the SQL
>> server agent and SQL Mail section of SQL Server 2000 do I need to
>> purchase a
>> license for the copy of Outlook I will use on the server even though we
>> wll
>> not actually be using Outlook on that server as a full client?

Outlook licensing on SQL Server

Hi
Just a quick question, if I use outlook as the MAPI client for the SQL
server agent and SQL Mail section of SQL Server 2000 do I need to purchase a
license for the copy of Outlook I will use on the server even though we wll
not actually be using Outlook on that server as a full client?I forgot to ask if it also means that we need a, Exhange CAL for the SQL
server as Outlook will be communicating with our Exchange server
"OGTI" wrote:

> Hi
> Just a quick question, if I use outlook as the MAPI client for the SQL
> server agent and SQL Mail section of SQL Server 2000 do I need to purchase
a
> license for the copy of Outlook I will use on the server even though we wl
l
> not actually be using Outlook on that server as a full client?|||Hi.
You need the appropriate Office license and an Exchange CAL.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"OGTI" <OGTI@.discussions.microsoft.com> wrote in message
news:66B8929F-3E51-4CBD-8707-D03834C372DE@.microsoft.com...[vbcol=seagreen]
>I forgot to ask if it also means that we need a, Exhange CAL for the SQL
> server as Outlook will be communicating with our Exchange server
> "OGTI" wrote:
>

Other ways to execute Integration package?

Hi all,
I am just wondering is there any other ways to execute an integration service package other than using sql server agent, dos command and manually execute the package in BIDS? I am thinking of running the package on web, is this possible?
What I am trying to do is let user to run the integration service when they need to, so instead using SQL Server Management Studio to run the task being set in SQL Server Agent, I am thinking of something where user can log into a website (like the report server) and then run the integration, so that the data for the report server's reports are being update. Please help out if any know a solution to it. Thanks in advance.

Daren
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=110020&SiteID=1

Orphaned Subscriptions

Running Win2k & SQL 2k
How do I remove orphaned subscriptions? I have several subscriptions that
appear in the distribution agent of the publisher that do not exist on the
subscriber.
Is there an SP to remove these? Is there a way I can do it manually?
TIA,
Larry...
It seems that ActiveX distribution and merge agents, as well as the merge
agents created with SQL CE subscribers are prone to not being cleaned up
correctly. Or perhpas I'm doing something incorrect.
First off make sure the agents aren't still running at the publisher. Use
sp_MSenum_replication_agents to determine the names of the active agents.
You have to pass the agent type
1=snapshot
2=logreader
3=distribution
4=merge
5=misc
9=queue reader
Then you have to determine the agent status, to do this change to the
distribution database and issue the following
sp_MSenum_distribution 'AgentName'
0=initializing
1=starting
2=stopped
3=running
4=idle
5=retry
6=failed
Once you have figured out the agent status you can begin to delete them.
In your subscription database issue an sp_helpsubscription or
sp_helpmergesubscription
Delete the subscription using sp_dropsubscription or
spdropmergesubscription. Use the values obtained from the above two
commands. Issue this in the publication database.
If this doesn't work you have to manually edit the system tables.
Hilary Cotter
Looking for a SQL Server replication book?
Now available for purchase at:
http://www.nwsu.com/0974973602.html
"Larry" <Larry@.discussions.microsoft.com> wrote in message
news:A1882E7A-AFCC-4A56-A07E-2B93BDDD6F6B@.microsoft.com...
> Running Win2k & SQL 2k
> How do I remove orphaned subscriptions? I have several subscriptions that
> appear in the distribution agent of the publisher that do not exist on the
> subscriber.
> Is there an SP to remove these? Is there a way I can do it manually?
> TIA,
> Larry...

Orphaned Sessions

Hi,
I have a SQL Agent task that fails, however the session carries on
regradless and compeltes the task successfully. The task is a call to a
stored procedure, and the Agent just gives an error of unknown token.
Running SQL 2000 sp3a on Windows nt4 server.
Can anyone shed any light on this?Hi
Have you checked the log files for the agent and SQL Server?
Does your stored procedure have error checking?
John
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:90531DDC-DAF8-4A74-9BEB-3FF5B01F7081@.microsoft.com...
> Hi,
> I have a SQL Agent task that fails, however the session carries on
> regradless and compeltes the task successfully. The task is a call to a
> stored procedure, and the Agent just gives an error of unknown token.
> Running SQL 2000 sp3a on Windows nt4 server.
> Can anyone shed any light on this?|||Hi,
Yes checked both log files and nothing.
Yes the SP does have error handling.
Julian
"John Bell" wrote:

> Hi
> Have you checked the log files for the agent and SQL Server?
> Does your stored procedure have error checking?
> John
> "Julian" <Julian@.discussions.microsoft.com> wrote in message
> news:90531DDC-DAF8-4A74-9BEB-3FF5B01F7081@.microsoft.com...
>
>|||Hi
Can you post the code and which statement it is failing on?
John
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Orphaned Sessions

Hi,
I have a SQL Agent task that fails, however the session carries on
regradless and compeltes the task successfully. The task is a call to a
stored procedure, and the Agent just gives an error of unknown token.
Running SQL 2000 sp3a on Windows nt4 server.
Can anyone shed any light on this?
Hi
Have you checked the log files for the agent and SQL Server?
Does your stored procedure have error checking?
John
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:90531DDC-DAF8-4A74-9BEB-3FF5B01F7081@.microsoft.com...
> Hi,
> I have a SQL Agent task that fails, however the session carries on
> regradless and compeltes the task successfully. The task is a call to a
> stored procedure, and the Agent just gives an error of unknown token.
> Running SQL 2000 sp3a on Windows nt4 server.
> Can anyone shed any light on this?
|||Hi,
Yes checked both log files and nothing.
Yes the SP does have error handling.
Julian
"John Bell" wrote:

> Hi
> Have you checked the log files for the agent and SQL Server?
> Does your stored procedure have error checking?
> John
> "Julian" <Julian@.discussions.microsoft.com> wrote in message
> news:90531DDC-DAF8-4A74-9BEB-3FF5B01F7081@.microsoft.com...
>
>
|||Hi
Can you post the code and which statement it is failing on?
John
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!

Orphaned Sessions

Hi,
I have a SQL Agent task that fails, however the session carries on
regradless and compeltes the task successfully. The task is a call to a
stored procedure, and the Agent just gives an error of unknown token.
Running SQL 2000 sp3a on Windows nt4 server.
Can anyone shed any light on this?Hi
Have you checked the log files for the agent and SQL Server?
Does your stored procedure have error checking?
John
"Julian" <Julian@.discussions.microsoft.com> wrote in message
news:90531DDC-DAF8-4A74-9BEB-3FF5B01F7081@.microsoft.com...
> Hi,
> I have a SQL Agent task that fails, however the session carries on
> regradless and compeltes the task successfully. The task is a call to a
> stored procedure, and the Agent just gives an error of unknown token.
> Running SQL 2000 sp3a on Windows nt4 server.
> Can anyone shed any light on this?