SQLServerCentral / Discuss Content Posted by Kunal Das / Article Discussions / Article Discussions by Author

Using Xp_sendmail With the Recipients Generated From a Query

Blasphemy — Tue, 10 Jul 2001 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kdas/xp_sendmail.asp

Upgrading SQL Server 7.0 to SQL 2000

zatman — Thu, 16 May 2002 09:16:00 GMT

I have begun upgrading My SQL Servers. I have 2 servers that are in a Active/passive Cluster. The current operating system is Windows NT 4 Ent.Ed. I started to upgrade the secondary node to Windows 2000 Adv. Server. When I completed the upgrade, everything would fail over except the Sql Server service. How do I correct this. Also does anyone have a link to reliable step by step instructions on how I should handle Upgrading my SQL 7 Active/Passive Cluster to SQL 2000 and Windows NT 4 Ent. Ed. to 2000 Advance Server?? Thanks in Advance!!

xp_startmail and switching profiles

uday — Mon, 13 May 2002 22:54:00 GMT

Guys!I'm using SQL Mail to send out Emails to Customers re: outstanding Invoices. I also use SQL Mail on the same box to send out emails to our Sales Reps with summaries of outstanding invoices. Now, I've set up multiple outlook profiles on the server. I tried using xp_startmail @user = 'CreditControlDept'xp_sendmail .... (to customers)xp_stopmail @user = 'CreditControlDept'xp_startmail @user = 'InvoiceTracker'xp_sendmail...(to internal sales reps)xp_stopmail @user = 'InvoiceTracker'DOES NOT WORK!!! the profile does'nt switch at all. SQL Mail sends out all the emails using the profile that it started with. How can I use xp_startmail and xp_stopmail to switch between different user profiles.RegardsUday

Using SQL Server 2000 and XML to Monitor the Usage of your SMTP Server

Blasphemy — Sun, 25 Nov 2001 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/kdas/smtpxml.asp