How about using fn_get_sql instead of dbcc inputbuffer? That way the sql statement won't be truncated. 😉

I don't think I was inferring that I couldn't rename the fields, I was just saying that the task was a big chore in building the model.

There are no tools/wizards...

Sameer

Are you running on SQL 2000 or SQL 2005?

Thinking some sort of query on the sysjobhistory table in the msdb database would be what you're after.

Do you receive the same "... content restriction ..." message?

"Inbound" would be when mail is arriving at the mail server, "Outbound" would be when mail is leaving the mail server.

So the message might be text, what about any disclaimers, etc... that may be added to the outbound email?

I had one client that had similar problems sending plain text emails...

"Message rejected due to content restrictions"

This is a small clue which indicates why the message isn't being received 😀

One thing we use CLR code for is sending out alerts via SMS using a web service.

The usual culprit in this sort of scenario is that you haven't created the Outlook profile using the same credentials that the SQL Server services are using.

Try logging in to...

Just curious, what are you trying to achieve with these two statements?

CONVERT (VARCHAR (10),T1.LAST_UPD, 101) + ' ' + CONVERT (VARCHAR (10),T1.LAST_UPD, 8),

CONVERT (VARCHAR (10),T1.CREATED, 101) + ' ' +...

The closest you're going to get is this tool,

http://www.geckoware.com.au/Content.aspx?Doc_id=1002

If that doesn't meet your needs then its time to re-evaluate your desired outcomes.

I mean really, who is going to...

To end up with data in different files, you will need to do some sort of data transfer process. Either DTS or BCP will suit your needs.

Another option is to...

Sounds like you'd be better off using replication. Have a look at transactional publications with updating subscriptions.

Check http://www.sqldts.com. They'll have an example of checking for the existence of the file.

Isn't that what I said 😉