Re: SQL Mail

I am not 100% sure what you are asking but you may want to have a look at
this utility to send email instead of xp_sendmail.

http://www.sqldev.net/xp/xpsmtp.htm

xp_sendmail requires a mapi client installed on each db server and can be
very difficult to get set up and keep running properly. The xpsmtp dll is
much easier to use and should solve your problem.

--
Andrew J. Kelly SQL MVP


"Roger" <naissani@xxxxxxxxxxx> wrote in message
news:%23XToEWs$FHA.2812@xxxxxxxxxxxxxxxxxxxxxxx
>I wanna ask one question regarding SQL Mail.... I wanna use xp_sendmail
>stored procedure in user defined stored procedures, but the question is
>that what would be the connection string. We have a three websites running
>and all three have different Users and Password, but the problem is that I
>want to use XP_SendMail account in two databases user defined stored
>procedures.
>
> I would highly appreciate if any one can explain me regarding the
> connection string user id and password like shoud I connect Windows Domain
> User ID and Password or SQL Server UserID and Password.
>
>
> Thanks in advance.
>
>
>


.

Relevant Pages

  • Re: Could not find Stored Procedure
    ... .CommandType make sure it's CommandType.StoredProcedure. ... run the code I get the error message "Could Not Find Stored Procedure ... I have even used SQL Profiler to watch the ... connection string to ensure I was connecting to the correct database. ...
    (microsoft.public.dotnet.framework.adonet)
  • SQL Mail
    ... I wanna ask one question regarding SQL Mail.... ... what would be the connection string. ... to use XP_SendMail account in two databases user defined stored procedures. ...
    (microsoft.public.sqlserver.clients)
  • SQL Connection Strings
    ... Data returned from Sql through a stored procedure is dependent on what user ... If the connection string is NOT unique, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Views vs Stored Procedures, whats the difference?
    ... I hope you are not suggesting you embed SQL queries into the application? ... A stored procedure logic will be exactly as fast as the algorithm you ... I understant that SQL Server supports hints. ... implementations (nestedloop, merge, hash, ..) on decent sized tables, then ...
    (comp.databases.ms-sqlserver)
  • Re: Stored Procedures - Patterns and Practices
    ... >published the reasoning behind its opinions. ... I disagree that the debate in SQL Server related discussion forums ... If the natural key is long or spans too many ... I want to call a stored procedure that adds a customer ...
    (microsoft.public.sqlserver.programming)
Loading