Got it. Thanks

Okay! I will start working on the same and let you know. Thanks again

Just one question to ask, where should I get SSIS is MS SQL 2008?

Hello all SQL Gurus,

Thank You for your all valuable suggestions.

I am a very basic developer just do know how to create table & views in MS SQL, dont have deep...

Dear Inoland,

I will surely keep the error message. Thanks for the Guidance

Dear InoLand,

Thank you for this valuable suggestion.

The insert part will one-by-one only, not multiple insert as this a very crucial part and that's why only one person will have the...

Hello Lowell,

I did it.

Thanks for the help 😀

Now, I don't need any bat file, I can directly do it through the trigger itself to create folder in other network drive....

Sir,

I Enable the SERVER PROXY ACCOUNT, but to understand the 2nd & 3rd screenshot. Can please elaborate the 2nd & 3rd screenshots?

I need to give the SQL Server the right...

I am getting following result of the T-SQL

IDTheOutput

1nt authority\system

2NULL

3NULL

4Access is denied.

5NULL

Thank You Sir. Will check and confirm for any error

Thanks a lot...:-)

Yes, I changed that part.

But, one more query, how can I include NAME column and send mail individually?

like:

Dear John Carter

Happy Birthday

to john@gmail.com

OR

Dear Mia Suzki

Happy Birthday

to mia@hotmail.com

Can you help...

I did this T-SQL:

DECLARE @p_body as nvarchar(max), @p_subject as nvarchar(max)

DECLARE @p_recipients as nvarchar(max), @p_profile_name as nvarchar(max)

DECLARE @xml NVARCHAR(MAX)

SET @p_profile_name = N'Birthday Wish Admin'

SET @p_recipients = (SELECT Stuff((SELECT N'; ' +...

OK..let me go ahead and get my T-SQL ready, if some error comes up, will take your help..thanks a lot for guidance

Sorry I have no idea for pseudo code..:ermm:

I just want to send a personalized message like this:

Dear John Carter,

Wish a very Happy and Prosperous Birthday.

Regards,

Administrator

I am new to Database Mail, what T-SQL should I opt to this?