About Me

My photo
Kottarakara, Kollam, Kerala, India
Though currently in Thiruvananthapuram, my residence is at Kollam district in Kerala which is almost 75 kms away from the office

I Me Myself !

Hi all, as a ASP.NET professional i would like to use this as a technological and informative site. Maybe, this contains my personal portfolio, funny matters, videos, photos too. Still i mainly intend to use this for official purpose.

Currently specialising in Microsoft's Dynamic CRM 4.0, am engaged in an assignment to successfully develop and deploy a CRM product as per the custom business logic. I am employed in a microsoft partnered switzerland based firm, know more...

The technologies/languages/packages i am confident in are:


  1. ASP.NET (vb/C#)

  2. C#.net

  3. vb.net

  4. sql server

  5. Adobe photoshop

  6. Macromedia Flash

  7. MS Dynamics CRM 4.0

My achievements includes:
1) Cisco Certified Network Associate (CCNA).
2) Active member of ASP.NET forum.
3) Active member of CRM Dynamics Community.

My professional career:


  • Web Designer at AUFIDUS INDESIGNS, Ernakulam, Kerala

  • Computer Lecturer at SRV Govt Higher Secondary School, Ernakulam, Kerala

  • Software Instructor at IGNOU, Ernakulam, Kerala

  • Lower Divison Clerk (LDC) at Melattur Grama Panchayat, Malappuram, Kerala

  • Software Trainer in .NET at Sun Infosys, Kottayam, Kerala

  • Software Trainer in .NET at NIIT, Adoor, Kerala

  • Computer Lecturer at UIT, Adoor, Kerala

  • Senior Systems Executive at PIT Solutions, Technopark, Thiruvananthapuram, Kerala

Database Mailing in SQL 2005

We may come across the situations that to send mails from SQL server automatically or manually in-order to retrieve some status or information. For that we can setup the database mailing feature of sql and all through sql query itself. Hmmm..thats great

--STEP 1 - CONFIGURING MAIL
--******************************************
use master
go
sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'Database Mail XPs',1
go
sp_configure 'SQL Mail XPs',0
go
reconfigure
go

--STEP 2 - CREATING MAIL ACCOUNT
--*********************************
EXECUTE msdb.dbo.sysmail_add_account_sp
@account_name = 'PITSAccount',
@description = 'PITS Mail account for Database Mail',
@email_address = 'binukumar@MYWORLD.com',
@display_name = 'PITS Account',
@username='binukumar@MYWORLd.com',
@password='TESTPASS',
@mailserver_name = 'smtp.TESTWORLD.yahoo.com'

--STEP 3 - CREATING MAIL PROFILE
--*********************************
EXECUTE msdb.dbo.sysmail_add_profile_sp
@profile_name = 'PITS Profile',
@description = 'PITS Profile used for database mail'

--STEP 4 - Connecting PROFILE with MAIL
--***************************************
EXECUTE msdb.dbo.sysmail_add_profileaccount_sp
@profile_name = 'PITS Profile',
@account_name = 'PITSAccount',
@sequence_number = 1

--STEP 5 - setting up the role and making this defauĆ¼t mail account
--***********************************************************************
EXECUTE msdb.dbo.sysmail_add_principalprofile_sp
@profile_name = 'PITS Profile',
@principal_name = 'public',
@is_default = 1 ;

--STEP 6 - SENDING MAIL
--********************************
declare @body1 varchar(100)
set @body1 = 'Server :'+@@servername+ ' My First Database Email '
EXEC msdb.dbo.sp_send_dbmail
@profile_name='PITS Profile',
@recipients='binukumar@myworld.com',
@subject = 'PITS Mail Test from SQL',
@body = @body1,
@body_format = 'HTML' ;

Now go and check the account of the target person we intended to sent the mail. The mail will be there for sure. Please let me know if any troubles