xp_sendmail cmd

xp_sendmail cmd

Post by Sharon Li » Sat, 04 Jan 1997 04:00:00



Hi, All:



Sharon

--
======================================================

Automation Engineer             Work: (216) 585-5618
Bailey Controls Company         http://www.bailey.com

 
 
 

xp_sendmail cmd

Post by Sharon Li » Sat, 04 Jan 1997 04:00:00



> Hi, All:




I found the answer!!

--
======================================================

Automation Engineer             Work: (216) 585-5618
Bailey Controls Company         http://www.bailey.com

 
 
 

1. using xp_sendmail and the @cmd



this:

Select test_1 = Select name from employee where id = 3444

Select test_2 = Select t_date from purchasing where id = 3333

The problem is that in my email I have a blank line between the data
retrieved by the 2 selects:

Robbie

12/12/00

Is there a way to keep the blank line from displaying between the data?
Thanks for any help.

2. keyset cursors against linked servers requires repeatable_read or serializable isolation levels

3. set rs = cmd.Execute fails when cmd.CommandText includes spaces

4. US-NJ: Secaucus-Oracle Financials PL/SQL

5. EXEC(@cmd)... Handling @cmd string > varchar(255)

6. Lock Timeout

7. ADODB Cmd with DSN

8. Please help. Date criteria is totally ignore when querying against Oracle 8.1.7 DB with OLEDB

9. Unique table, Resync Cmd

10. Workflow Using CMD

11. Using osql with cmd execution jobs in SQL 2000

12. cmd.Properties("Output Stream").Value = objStream Error

13. Starting Jobs from Cmd prompt?