Foe SQL 2005 and 2008, use:

EXEC msdb..sp_send_dbmail

@profile_name='Default',

@recipients= 'xyz@yahoo.com',

@subject= 'Test 1',

@body = 'This is a test message.',

@file_attachments = null,

@importance = 'HIGH',

@sensitivity ='CONFIDENTIAL'

Found one possible solution:

The SMTP server (set up in table msdb.dbo.sysmail_server) needs to be routed through Microsoft exchange server. Once the SMTP server has been routed through Microsoft exchange...

Thank you Ten and Lowell:

When we send out e-mail using Microsoft Outlook, if we put the word ‘SECURE’ in subject line, the user will receive the e-mail notice and they...

Thank You,

The following folder need to be created:

C:\Windows\SysWOW64\config\systemprofile\Desktop

My system administrator is being able to fix this problem. He gives me a link:

http://social.msdn.microsoft.com/Forums/en-US/innovateonoffice/thread/b81a3c4e-62db-488b-af06-44421818ef91?prof=required

Thanks my system administrator.

Mary Ming Wang

Has the problem 'Unable to get the Open property of the Workbooks class' been resolved? If so, would you please let me know what method did you use?

I’m encountering the...

I found an instant quick fix for my problem; I write the xp_cmdshell output into a table, than check the table to see if there are any ‘Not connected’ or...

I'll keep in mind.

Thanks.

Thank you for the suggestions.

Because the ftp open its own shell, the xp_cmdshell will return ‘0’ if the remote server busy or not available at file transmission time, are...