[dba-SQLServer]Auto email users from SS7 on the 1st of month.

I wouldn't, but the company's policy dictates otherwise, so CDO is the solution.

Robert Djabarov
Senior SQL Server DBA
USAA IT/DBMS
? (210) 913-3148 - phone
? (210) 753-3148 - pager


 -----Original Message-----
From: 	Chris McIsaac [mailto:cjm at haleyaldrich.com] 
Sent:	Friday, July 11, 2003 7:44 AM
To:	dba-sqlserver at databaseadvisors.com
Subject:	RE: [dba-SQLServer]Auto email users from SS7 on the 1st of month.

Just curious...why do you avoid using sqlmail?

-----Original Message-----
From: Djabarov, Robert [mailto:Robert.Djabarov at usaa.com]
Sent: Thursday, July 10, 2003 5:31 PM
To: dba-sqlserver at databaseadvisors.com
Subject: RE: [dba-SQLServer]Auto email users from SS7 on the 1st of
month.


You can use CDO object model to avoid having to have SQLMail running on your server.  Also, here's a stored procedure that you can use as a sample.
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com