Kapil Singh

Hi friends, I am Kapil Singh Kumawat and I am from Jaipur in Rajasthan, India. I have been working with SQL Server for the last four and a half years and am currently working with Cognizant Technology Solutions as an SQL Server Developer. I have experience in performance tuning, SSIS, data migration, database designing and writing queries. My other interests include travelling, watching football and listening to music.

All authors

Sysmail_help_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 10

by Kapil Singh

Kapil Blogs

Hi friends, in this blog of SQL Server database mail stored procedure we will continue with another database mail stored...

2015-06-15

398 reads

Sysmail_add_principalprofile_sp – SQL Server Database Mail Stored Procedure – Part 9

by Kapil Singh

Kapil Blogs

Hi friends, in this blog of SQL Server Database mail stored procedure we will continue with another database mail procedure sysmail_add_principalprofile_sp....

2015-06-13

470 reads

Sysmail_help_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 8

by Kapil Singh

Kapil Blogs

Hi folks, in our previous blog of SQL Server Database Mail stored procedure we added database mail account to database...

2015-06-08

407 reads

Sysmail_add_profileaccount_sp – SQL Server Database Mail Stored Procedure – Part 7

by Kapil Singh

Kapil Blogs

Hi friends, in last previous blogs we created database mail profile and database mail account. In this blog we will...

2015-06-04

478 reads

What is User Defined function in SQL Server?

by Kapil Singh

Kapil Blogs

User-defined functions encapsulate T-SQL statement and return a table or a scalar value to the caller. UDFs can not be...

2015-06-01

355 reads

Sysmail_help_Account_sp – SQL Server Database Mail Stored Procedure – Part 6

by Kapil Singh

Kapil Blogs

Hi friends, in this blog we will learn how to get information about database mail account using stored procedure sysmail_hep_account_sp....

2015-05-30

861 reads

Sysmail_add_account_sp – SQL Server Database Mail Stored Procedure – Part 5

by Kapil Singh

Kapil Blogs

Hi friends, today we will continue with database mail stored procedure and will learn how to create database mail account...

2015-05-28

954 reads

Sysmail_help_profile_sp – SQL Server Database Mail Stored Procedure – Part 4

by Kapil Singh

Kapil Blogs

Hi friends, today we will learn how to get information about database mail profile using stored procedure sysmail_help_profile_sp. Sysmail_help_profile_sp stored...

2015-05-26

325 reads