How to use Database mail feature in SQL Server 2000

• M&M

  SSC-Insane

  Points: 21700

  More actions

  November 11, 2011 at 6:39 am

  #1406219

  I am not quite sure on this one.

  M&M

• danskisanjar

  SSC Enthusiast

  Points: 172

  More actions

  November 11, 2011 at 8:16 am

  #1406303

  That is ok. You have been a big help to me. Thanks!

• CliveW

  Old Hand

  Points: 339

  More actions

  June 12, 2012 at 8:47 am

  #1499837

  Nice article all set-up and works fine in Query Analyser but fails as a job this is down to the way our servers are named any suggestions on getting round this.

  In Query Analyser can use.

  exec "res-sql-002".msdb.dbo.sp_send_dbmail

  @profile_name = 'SampleSQLServer2005dbmailProfile',

  @recipients='yourname@email.com', --@copy_recipients = 'yourgroup@email.com',

  @subject='Job test_db_mail failed on SQL Server 2000 server',

  @importance='HIGH',

  @body ='Job test_db_mail failed on SQL Server 2000 server'

  But soon as trying to add within a job will not parse with error around the -sql-

  Error 170 line 1 Incorrect syntax near sql

• Richard Moore-400646

  SSCrazy

  Points: 2384

  More actions

  June 12, 2012 at 8:51 am

  #1499841

  Place [] around the database name.

• CliveW

  Old Hand

  Points: 339

  More actions

  June 12, 2012 at 9:16 am

  #1499867

  Thanks for that realised 5 minutes after posting this. all working fine now.

  Thanks again.