<div>
Can you please paste your stored procedure code ? 
 
Have you tried looking at your Exchange Server log to see if you can find anything over there ? 
 
Cheers, 
 
Aash.
</div>

<div>
how to check the exchange server log? 

</div>

<div>
 

<pre><code class="code-10 nolinks" id="code-120608">--This is my own stored procedure where I call the sp_send_dbmail
Create PROCEDURE sp_SalesCase_SendEmail
( 
 @Message as text, 
 @EmailSubject as varchar(300), 
 @CustomerEmail as varchar(50) 
) 
AS 
 
DECLARE @emailMessage as varchar(4000) 
 
SELECT @emailMessage = CAST(@Message as char(4000)) 
 
 
If @emailMessage= ''
	Begin
 
		Declare @TestSubject As Varchar(300)
		Select @TestSubject= 'At ' + CAST(GetDate() as Varchar(50)) + ' empty message found in Stored Procedure for ' + @CustomerEmail
		EXEC [DB-temp].msdb.dbo.sp_send_dbmail 
			@profile_name='Test', 
			@recipients='test@yahoo.com', 
			@subject = @TestSubject, 
			@body=@EmailSubject, 
			@exclude_query_output = 1 
	End
Else
	Begin
		EXEC [DB-temp].msdb.dbo.sp_send_dbmail 
			@profile_name='Test', 
			@recipients='customer@yahoo.com',
			@subject = @TestSubject, 
			@body=@EmailSubject, 
			@exclude_query_output = 1 
	End
 
 
SELECT 0 
 
</code></pre>
</div>

<div>
Please try below code. I hope it makes sense. 
 
Cheers, 
 
aash 

<pre><code class="code-10 nolinks" id="code-120621">Create PROCEDURE sp_SalesCase_SendEmail
( 
 @Message as text, 
 @EmailSubject as varchar(300), 
 @CustomerEmail as varchar(50) 
) 
AS 
 
DECLARE @emailMessage as varchar(4000) 
 
SET @emailMessage = SELECT CAST(@Message as char(4000)) 
 
 
If @emailMessage= ''
	Begin
 
		Declare @TestSubject As Varchar(300)
		Select @TestSubject= 'At ' + CAST(GetDate() as Varchar(50)) + ' empty message found in Stored Procedure for ' + @CustomerEmail
		EXEC [DB-temp].msdb.dbo.sp_send_dbmail 
			@profile_name='Test', 
			@recipients='test@yahoo.com', 
			@subject = @TestSubject, 
			@body=@EmailSubject, 
			@exclude_query_output = 1 
	End
Else
	Begin
		EXEC [DB-temp].msdb.dbo.sp_send_dbmail 
			@profile_name='Test', 
			@recipients='customer@yahoo.com',
			@subject = @TestSubject, 
			@body=@EmailSubject, 
			@exclude_query_output = 1 
	End
 
 
SELECT 0 
</code></pre>
</div>

<div>
arent select or set will do the same thing ?
</div>

<div>
I dont think they are same. Try it. Wont harm anything will it. 
 
Have you tried sending a test email from Test Profile after setting up the profile. 
 
Cheers, 
 
Aash.
</div>

<div>
Oh i see, I will do it now 
 
But actually I didnt know about the profile is something could be wrong with in the profile as well?
</div>

<div>
Dont you need to specify the value for variable @EmailSubject as varchar(300), which is used in the body part of the email. 
 
It needs to know what to send in the body. Any select statment or anything. 
 
I hope it makes sense. 
 
Cheers, 
 
Aash.
</div>

<div>
You asked me about checking the exchange server log but my SQL server 2005 is sending email through IIS using Smtp 
 
Thanks
</div>

<div>
if you are talking this part of the stored procedure 
 
 
 
If @emailMessage= '' 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Begin 
 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Declare @TestSubject As Varchar(300) 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Select @TestSubject= 'At ' + CAST(GetDate() as Varchar(50)) + ' empty message found in Stored Procedure for ' + @CustomerEmail 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;EXEC [wiggle-sql-04].msdb.dbo.sp_send_dbmail &nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@profile_name='Sales', &nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@recipients='ken@wiggle.co.uk', &nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@subject = @TestSubject, &nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@body=@EmailSubject, &nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;@exclude_query_output = 1 &nbsp; 
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;End 
 
 
I put it because to check if the message is comming empty as an argument so I will send email to myself 
to debug problem 
Thanks
</div>

<div>
I was trying to mention @EmailSubject variable which you have declared. 
 
Cheers, 
 
Aash.
</div>

<div>
I am sorry but I dont understand 
The @EmailSubject is input parameter whic I am using to pass the subject for email 
 
Also as you can see the code in the snipest 
In this code I have the actual email is going through the else clause the code in the If clause is about I am trying to catch if the message is empty I will send email to myself 
Can you please explain agian what are you trying to tell me ? 
Thanks 

<pre><code class="code-10 nolinks" id="code-120634">If @emailMessage= ''
	Begin
 
		Declare @TestSubject As Varchar(300)
		Select @TestSubject= 'At ' + CAST(GetDate() as Varchar(50)) + ' empty message found in Stored Procedure for ' + @CustomerEmail
		EXEC [wiggle-sql-04].msdb.dbo.sp_send_dbmail 
			@profile_name='Sales', 
			@recipients='ken@wiggle.co.uk', 
			@subject = @TestSubject, 
			@body=@EmailSubject, 
			@exclude_query_output = 1 
	End
Else
	Begin
		EXEC [wiggle-sql-04].msdb.dbo.sp_send_dbmail 
			@profile_name='Sales', 
			@recipients=@CustomerEmail, 
			@subject = @EmailSubject, 
			@body=@emailMessage, 
			@exclude_query_output = 1 
	End
</code></pre>
</div>

<div>
<div class="content wysiwyg-content">
I am using a stored procedure to send email through the SQL Server 2005 
using sp_send_dbmail 
The problem is that recipent is receiving an email but sometimes it appearing with empty message. 
If we just resend the same email again the problem disappear. 
I had &nbsp;tested and to see may be I am not passing the message correctly but its look like I am passing it properly but some how message is disappearing for some emails 
 
Thanks 

</div>
</div>

I am using a stored procedure to send email through the SQL Server 2005
using sp_send_dbmail
The problem is that recipent is receiving an email but sometimes it appearing with empty message.
If we just resend the same email again the problem disappear.
I had  tested and to see may be I am not passing the message correctly but its look like I am passing it properly but some how message is disappearing for some emails

Thanks


Empty Message problem while sending email by sp_send_dbmail

Development in most programming languages is frequently done with an editor or integrated development environment (IDE). An IDE is a software application that provide comprehensive facilities to computer programmers for software development. An IDE normally consists of a source code editor, build automation tools and a debugger. XCode, Visual Studio, Adobe Dreamweaver and Eclipse are some of the more popular development tools, but an editor or IDE can be anything from simple text editors to sophisticated programs. Related topics: All programming and development language, database and web based content management systems topics

Editors IDEs

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.