Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2K SMTP mail on Windows 2K Expand / Collapse
Author
Message
Posted Sunday, September 23, 2007 6:18 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, March 9, 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
Posted Monday, December 10, 2007 9:52 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Wednesday, December 19, 2007 10:37 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Monday, August 10, 2009 6:23 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum 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
Posted Sunday, October 7, 2012 1:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, October 7, 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 »

Add to briefcase

Permissions Expand / Collapse