SQL 2K SMTP mail on Windows 2K

Question

SQL 2K SMTP mail on Windows 2K

Clinton Herring

Ten Centuries

Points: 1160
More actions
September 23, 2007 at 6:18 pm

#198174

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Carl Alderton Grasshopper Points: 19 More actions · Answer 1

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!

Edwin Thomson Grasshopper Points: 19 More actions · Answer 2

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?

jkiranbabu SSC Rookie Points: 35 More actions · Answer 3

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.

vs.naveen SSC Enthusiast Points: 143 More actions · Answer 4

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.