They are probably carriage return/line feed characters. Have you got the header row delimiter set to {CR}{LF} in the connection manager?

I'd be tempted just to copy the data from server B to server A, run my query with an inner join and then delete the newly copied data from server...

I suspect they're only...

Leo Hesen (5/27/2009)

---

Made the obvious mistake myself.

My assumption:

1 Not correct

2 Not correct

So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to...

That's more like the answer I'd expected than the answer I'd hoped for, but thanks.

I know this is less of an issue with Database Mail than SQL Mail, but if your mail service fails then your trigger will fail too. I've got into the...

Same issue here. I did notice that my insert query wasn't actually returning any rows, so changed the job from

INSERT INTO Table (Field1, Field2, Field3)

SELECT a.F1, a.F2, a.F3 FROM Table2

to

IF...

Ooh - that's much better. I knew I was looking at this the wrong way. Thank you.

That's correct. TRXID is a unique value in my source data, but not in my desired output. I should also add that in the source I can't guarantee that the...

RTRIM has no effect. I suppose fewer spaces is an improvement, but the client won't be happy until there are none. It's good, but it's not right.

Hi Jack

Setting @width=25 just pads each line out to 25 characters, which isn't the desired effect.

Instead of using xp_sendmail like this, I create a table with fields for recipient, subject, message body and a nullable date field message_sent. I then have a job running every...

Looks like I'll carry on kludging then. Thanks for the help.

Scott

The metadata says DT_NUMERIC (38,0) for the column, even when I do an explicit cast to decimal(10,2) in the source query. I can't see a way to edit the metadata.

Scott

Can you do this on a remote server? We have a mirrored database and I want to write a script to enable and disable jobs on both servers in the...