Database Mail Error

• Dale Hughes-356583

  Right there with Babe

  Points: 759

  More actions

  October 9, 2009 at 12:53 pm

  #1064310

  Using SSMS, open the script in a query window with a connection to the instance you're having the problem with. It will only affect the instance you're connected to, nothing else. It does affect the system databases, but again, only in the instance you're connected to.

  Run some backups first just to be safe

  Dale

• jude-32296

  Default port

  Points: 1412

  More actions

  October 9, 2009 at 1:33 pm

  #1064328

  OOPS!!! Sent the "You Rock" thanx so much to the wrong thread....but you do, so I'll say it again, YOU ROCK!!!

• Chris Mackin-166947

  SSChasing Mays

  Points: 653

  More actions

  May 12, 2011 at 10:13 am

  #1323799

  Just in case someone else is running into this issue. I am running SQL 2005 sp4 and was having DB Mail issues, following this instruction:

  " rerun the script "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\install\sysdbupg.sql""

  fixed my issue.

  Thanks!!