Wednesday, March 28, 2012

Outlook

Folks,
Can you point me to where I can look for more info to complete this task.
There is a proprietary app running with SQL 2000 as backend. Everynight the
app put DB in single user mode and runs DBCC itself to check data. That
runs well except few times it failed to get exclusive login in order to
clear single user mode. It causes the app fails to open. I think I may
want to run a script at my computer querying the DB and notify someone by
using Outlook on my computer. Is there any info that can tell me how to
open Outlook from in inside sql script?
Thanks,Hi,
try to use xp_sendmail. but you don't need the database in
single user to run dbcc checkdb, you only need single user
mode if you use the repair option.
CMLC
>--Original Message--
>Folks,
>Can you point me to where I can look for more info to
complete this task.
>There is a proprietary app running with SQL 2000 as
backend. Everynight the
>app put DB in single user mode and runs DBCC itself to
check data. That
>runs well except few times it failed to get exclusive
login in order to
>clear single user mode. It causes the app fails to
open. I think I may
>want to run a script at my computer querying the DB and
notify someone by
>using Outlook on my computer. Is there any info that can
tell me how to
>open Outlook from in inside sql script?
>Thanks,
>
>.
>|||hi,
to use xp_sendmail we must have SQL mail configured on the SQL box. This is
not my case because I can't touch the box. What I wanted is to use Outlook
on my pc to send email out. Is it possible?
> you don't need the database in single user to run dbcc checkdb, you only
> need single user mode if you use the >repair option
the app is proprietary so ... no touching. It seems that it would repair
data if possible.
"CMLC" <anonymous@.discussions.microsoft.com> wrote in message
news:196d01c4a188$bc87d820$a401280a@.phx.gbl...
> Hi,
> try to use xp_sendmail. but you don't need the database in
> single user to run dbcc checkdb, you only need single user
> mode if you use the repair option.
> CMLC
>
>>--Original Message--
>>Folks,
>>Can you point me to where I can look for more info to
> complete this task.
>>There is a proprietary app running with SQL 2000 as
> backend. Everynight the
>>app put DB in single user mode and runs DBCC itself to
> check data. That
>>runs well except few times it failed to get exclusive
> login in order to
>>clear single user mode. It causes the app fails to
> open. I think I may
>>want to run a script at my computer querying the DB and
> notify someone by
>>using Outlook on my computer. Is there any info that can
> tell me how to
>>open Outlook from in inside sql script?
>>Thanks,
>>
>>.|||Hi,
Thanks for your post.
From your descriptions, I understood that you would like to notify the
logon customer by email but you cannot configure your SQL Profile. Correct
me if I was wrong.
Based on my scope, You can use other methods to send Simple Mail Transfer
Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
OLE Automation stored procedures. See the following documents for more
detailed information
HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
http://support.microsoft.com/?kbid=312839
Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
for sending MIME based email over SMTP, implemented as an Extended Stored
Procedure.
XPSMTP.DLL - SQL Server SMTP Mail XP
http://www.sqldev.net/xp/xpsmtp.htm
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
This document contains references to a third party World Wide Web site.
Microsoft is providing this information as a convenience to you. Microsoft
does not control these sites and has not tested any software or information
found on these sites; therefore, Microsoft cannot make any representations
regarding the quality, safety, or suitability of any software or
information found there. There are inherent dangers in the use of any
software found on the Internet, and Microsoft cautions you to make sure
that you completely understand the risk before retrieving any software from
the Internet.|||Thank you. It's what I wanted. I was thinking of a much more complicated
Outlook approach.
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>|||It works great for me. However is there any pros or cons of sending mail
out using CDOSYS such as security?
""Mingqing Cheng [MSFT]"" <v-mingqc@.online.microsoft.com> wrote in message
news:$y5iBpeoEHA.740@.cpmsftngxa06.phx.gbl...
> Hi,
> Thanks for your post.
> From your descriptions, I understood that you would like to notify the
> logon customer by email but you cannot configure your SQL Profile. Correct
> me if I was wrong.
> Based on my scope, You can use other methods to send Simple Mail Transfer
> Protocol (SMTP) e-mail directly from SQL Server. For example, you can use
> Collaboration Data Objects for NT Server (CDONTS) or Collaboration Data
> Objects for Windows 2000 (CDOSYS) in combination with the sp_OA SQL Server
> OLE Automation stored procedures. See the following documents for more
> detailed information
> HOW TO: Send E-Mail Without Using SQL Mail in SQL Server
> http://support.microsoft.com/?kbid=312839
> Secondly, http://www.sqldev.net/ provides a SMTP based SQL Mail solution
> for sending MIME based email over SMTP, implemented as an Extended Stored
> Procedure.
> XPSMTP.DLL - SQL Server SMTP Mail XP
> http://www.sqldev.net/xp/xpsmtp.htm
> Thank you for your patience and corperation. If you have any questions or
> concerns, don't hesitate to let me know. We are here to be of assistance!
>
> Sincerely yours,
> Mingqing Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Introduction to Yukon! - http://www.microsoft.com/sql/yukon
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
> This document contains references to a third party World Wide Web site.
> Microsoft is providing this information as a convenience to you. Microsoft
> does not control these sites and has not tested any software or
> information
> found on these sites; therefore, Microsoft cannot make any representations
> regarding the quality, safety, or suitability of any software or
> information found there. There are inherent dangers in the use of any
> software found on the Internet, and Microsoft cautions you to make sure
> that you completely understand the risk before retrieving any software
> from
> the Internet.
>|||Hi,
It's great to hear that my suggestion is suitable for you.
Collaboration Data Objects (CDO) for Microsoft? Windows? 2000 (Cdosys.dll),
which implements the 2.0 version of the Collaboration Data Objects API
specification, is a Component Object Model (COM) component designed to
simplify writing programs that create or manipulate Internet messages. You
could ask this exchange newsgroup, where I think will be more professional
answers there.
IMO, CDOSYS requires relatively high level of development instead of
xp_sendmail do. I would like to suggest upgrading to the lastest updates,
Windows 2000 SP4 and Office 2000 SP3 (if you had that Office installed).
See the documents below for detailed information about why these updates
are important
OL2000: Information About the CDO E-mail Security Update
http://support.microsoft.com/default.aspx?scid=kb;en-us;268279
OFF2000: How to Update an Administrative Installation with the Outlook CDO
Security Update
http://support.microsoft.com/default.aspx?scid=kb;en-us;268719
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!sql

No comments:

Post a Comment