SQL 2K SMTP mail on Windows 2K

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Clinton Herring » SQL 2K SMTP mail on Windows 2K

SQL 2K SMTP mail on Windows 2K

Rate Topic

Display Mode

Topic Options

Author

Message

Clinton Herring

Posted Sunday, September 23, 2007 6:18 PM

Valued Member

Group: General Forum Members
Last Login: Monday, March 09, 2009 1:35 PM
Points: 60, Visits: 12

Comments posted to this topic are about the item SQL 2K SMTP mail on Windows 2K

Post #401754

Carl Alderton

Posted Monday, December 10, 2007 9:52 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, September 17, 2010 7:49 AM
Points: 1, Visits: 63

Nice code, well layed out & well documented.
Because max on varchars doesn't work too well (it just works on the ascii value of the 1st character - e.g. '7' is greater than '12888234') maybe #fixeddrives should be declared as follows

Create table #fixeddrives(
Drive char(1) null,
FreeSpace bigint null)

Nice coding - it saved me a few hours!

Post #431402

Edwin Thomson

Posted Wednesday, December 19, 2007 10:37 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, December 19, 2007 10:37 AM
Points: 1, Visits: 3

What sort of license is this script distributed under? I'd like to use a modified version of it in a commercial project - is that allowed?

Post #434867

jkiranbabu

Posted Monday, August 10, 2009 6:23 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 17, 2011 7:24 AM
Points: 1, Visits: 21

When we are sending to the multiple email id's if any of the email id does not exists in our active directory then this mailing stored procedure will not work. The procedure expects all the email id’s for which we have to send mail and should be present in Active Directory.

Post #767785

vs.naveen

Posted Sunday, October 07, 2012 1:57 AM

Forum Newbie

Group: General Forum Members
Last Login: Sunday, October 07, 2012 1:53 AM
Points: 3, Visits: 65

Thanks for sharing this SP. this is so useful doesn't need any MAPI configuration in SQL. I was really struggling with the MAPI configuration which some times use to work and some times not. I was really worried about the solution. This is wonderful procedure which has made our life easy.

Post #1369505

« Prev Topic | Next Topic »

Permissions