abkblob

Sending Emails and atteching files using SMTP SQL server

2008-12-04T20:30:00.001-08:00

--This is a One Time Set UP

--Enable the Database Mail option

sp_configure 'show advanced options', 1;

RECONFIGURE;

sp_configure 'Database Mail XPs', 1; -- 0 to Disable and 1 to enable

RECONFIGURE

--Create a Database Mail account to send Email

EXECUTE msdb.dbo.sysmail_add_account_sp

@account_name = 'AS', --Give an Account Name

@description = 'Test Profile',

@email_address = 'abkthebond@siemens.com', --Using which SMTP account the mail will be sent

@display_name = 'Andy',

@mailserver_name = '134.144.122.244' --Address of the SMTP Server

--Create a Database Mail profile

EXECUTE msdb.dbo.sysmail_add_profile_sp

@profile_name = 'Anand',

@description = 'Test Profile'

--add the Database Mail account and Database Mail profile created in previous steps

EXECUTE msdb.dbo.sysmail_add_profileaccount_sp

@profile_name = 'Anand',

@account_name = 'Anand',

@sequence_number = 1

--Grant the Database Mail profile access to the msdb public database role and to make the profile the default Database Mail profile

EXECUTE msdb.dbo.sysmail_add_principalprofile_sp

@profile_name = 'Anand',

@principal_name = 'public',

@is_default = 1 ;

SQL SERVER : Code to create a calender Dataset

2008-12-04T20:28:00.001-08:00

create procedure GenerateCalenderforaMonth

@themonth datetime

set nocount on

Declare @StartDate as datetime

set @StartDate = cast(month(@themonth) as varchar(5)) + '/1/' + cast(year(@themonth) as varchar(5))

create table #temp

(

rowcounter int,

sunday datetime,

monday datetime,

Tuesday datetime,

wednesday datetime,

thursday datetime,

friday datetime,

saturday datetime

)

insert into #temp values (1,'1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028')

insert into #temp values (2,'1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028')

insert into #temp values (3,'1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028')

insert into #temp values (4,'1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028')

insert into #temp values (5,'1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028')

insert into #temp values (6,'1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028','1 dec 2028')

Declare @counter as int

Declare @RowCounter as int

Declare @strSQL as nvarchar(2000)

set @counter = 1

Set @RowCounter = 1

while @RowCounter <>

begin

set @counter = 1

while @counter <>

Begin

if @counter = datepart(dw, @StartDate)

begin

set @strSQL = 'update #temp set ' +

Cast(datename(dw, @StartDate) as Nvarchar(200)) + ' = '''

+ Cast(@StartDate as nvarchar(200))

+ ''' where rowcounter = '

+ Cast(@RowCounter as nvarchar(200))

exec(@strSQL)

set @StartDate = dateadd(dd,1,@StartDate)

end

set @counter = @counter + 1

end

set @RowCounter = @RowCounter + 1

end

C# code to read the automatic configuration script

2008-11-13T00:43:00.000-08:00

using System;
using System.Net;
public class Test
{
public static void Main(string[] args)
{
IWebProxy iwp11 = GlobalProxySelection.Select;
Console.WriteLine(iwp11.GetProxy(new Uri(args[0])).ToString());
//Console.ReadLine();
//comment the following 2 lines when compiling on 1.1
IWebProxy iwp20 = WebRequest.DefaultWebProxy;
Console.WriteLine(iwp20.GetProxy(new Uri(args[0])).ToString());

Console.ReadLine();

}
}

THE PAC FILE AT Localhost

function FindProxyForURL(url, host)

{ if(host == "http://www.example.com/")

return "PROXY MyProxy:9090";

else return "DIRECT"; }

RESULTS: