so you have a linked server for ISCSGSWEBUP01, right?

did you specify which credentials should be used when accessing it?

could it be that YOU, as a sysadmin, have matching credentials on...

i think it has to do with the way you have the linked server set up;

if you look at it graphically, you want to make sure the radio button that...

can you show a screenshot of your dbmail profile you created? that might give us some more information.

i like to use a company and contact as examples.

a Company is an entity.

a table describing that entity, might include fields for the name, address, website and more.

then an...

oops spoke too soon then.

Jacks suggestion on checking the firewall is the first thing to check.

if that is...

sweet! i was just about to post something about "Could not connect to mail server." and...

you are very welcome! good luck!

also, doublec check which email address you are using.

i know, for exmaple, from one of my mail servers, my from address must be the same as the email address realted...

wierd; you are getting the same error as before when you look in failed items?

SELECT

err.[description],

fail.*

FROM [msdb].[dbo].[sysmail_event_log] err

inner join [msdb].[dbo].[sysmail_faileditems] fail

...

glad you got it all sorted out!

wissam ismail (1/12/2012)

---

Hi

I have set up database mail.

I know the settings are correct because I use the same ones for MS Outlook on the same machine.

I am getting the following...

it might be easier to simply do it via TSQL:

select definition from sys.triggers

The idea is related to workflow and testing, and making sure you have a decent (rigid) testing dfunctionality before anything gets deployed to "production"

first, what are we trying to avoid:...

I'm under the impression that by using the default parameter, it reads all the automatically created rollover files.

http://msdn.microsoft.com/en-us/library/aa258856(v=sql.80).aspx

---

Users may specify the default value "default" to tell SQL Server to...

here's a snippet that woudl generate a CREATE view statement for your traces;

default naming convention of VW_TRACE_[traceid]

SELECT

' CREATE VIEW master.dbo.VW_Trace_' + CONVERT(varchar,id) + '

...