Are you referring to replication? If so, you can go to the publisher, expand "replication", expand the "Publications", choose the one you want and expand it, then right-click on the...

I don't understand what you are referring to. Can you please provide more detail?

Is the database engine running?

Sounds like a problem to me... Something was not configured correctly when setting up database mail. What if you go into the wizard and modify a profile all the way...

hat are the results if you remove the WHERE clause?

Figured it out...

SELECT *

FROM msdb.dbo.sysmail_profile p

JOIN msdb.dbo.sysmail_principalprofile pp

ON p.profile_id = pp.profile_id

WHERE pp.is_default = 1

:-)...

Sorry... My point there was that the default has been changed, but SQL Agent probably has not been restarted.

When did the default change from account3 to account2?

rocky (2/23/2012)

---

I appreciate the replies.

I did the selects on the system tables like anthonly suggested.

I see 3 dbmail profiles and accounts. when ANY job on the instance completes...

anthony.green (2/23/2012)

---

rocky (2/23/2012)

---

In looking at results from 'select * from msdb.dbo.sysmail_account' I do see the display name for another count is what's showing in the FROM: of the notification email....

Does this help?

From http://msdn.microsoft.com/en-us/library/ms188609.aspx

Comma-separated value (CSV) files are not supported by SQL Server bulk-import operations. However, in some cases, a CSV file can be used as the data file for...

The mail profile that the database mail uses to send is mutually exclusive from the operator; they are unrelated. An operator is who it sends to in this case....

dnolan5323 (2/23/2012)

---

Thanks for all you help guys. I know its not the prettiest way of doing things but i got things to work. I am using 'Event[' as my rowterminator...

David Burrows (2/23/2012)

---

Create a table with an IDENTITY column and a single varchar column set to max length of input line

bulk load the data

then select the relevent detail associated to...