since it's just this one server,
could it be something like database mail is not emabled, even though you've created the profile?
it sounds like maybe you scripted the database mail settings out and ran them, but not the configure?
http://msdn.microsoft.com/en-us/library/ms191189.aspx
use master
go
sp_configure 'show advanced options',1
go
reconfigure with override
go
sp_configure 'Database Mail XPs',1
go
sp_configure 'SQL Mail XPs',0
go
reconfigure
go
- This reply was modified 5 years, 1 month ago by Lowell.
- This reply was modified 4 years, 8 months ago by Lowell.
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!