the key is to look in the Output window for the issue:

i built a new project with your code, changed it to External and tried to deploy.

i had the wrong...

Manie the key is the specific error messages you see in msdb.sysmail_faileditems.

take a look at the data from this SELECT statement:

are all the err.[description], basically the same? what is the...

bad idea. bad bad.

first, don't do anything like take the database offline or anything without expert advice; Gail Shaw monitors this forum frequently..

run DBCC CHECKDB('db name') WITH NO_INFOMSGS, ALL_ERRORMSGS and...

there's no way, as far as i know, to use dbmail in a set based mode;

sending individual emails is one of the places I think a cursor is no problem....

you simply want to use a case statement;

something like this:

---

N'<th>Total Space(in GB)</th>'

+ CASE

WHEN [FreeSpace] <= 90.0

THEN N'<th><span style="color:#FF0000";>Free Space(in GB)<//span></th>'+

...

i'm guessing that the cross database call to a date formatting function is the culprit. the otehr database has a different collation.

try this (collating the function value) as the first...

although this solution will require a table scan, since the function on the column Name makes this non-SARG-able, this will work too:

select * from YourTable where DATENAME(dw,TheDate) = 'Saturday'

If I was ever dropped into this kind of situation, I'd hire Gail as a consultant - by - remote in a heartbeat, even if the money came out...

also consider that it sounds like you can skip bcp completely;

sp_sendmail has the option to include commad delimited results, including headers as an attachment.

here's a code sample:

EXEC msdb.dbo.sp_send_dbmail

...

latingntlman (5/29/2012)

---

Thanks, Lowell.

I went with option one and after some tweaks, I have my temp table. Now, I'm getting ready to exec EXECUTE master.dbo.xp_cmdshell but I can't find this anywhere....

bcp doesn't add headers, so you have to do it manually.

here's two examples i keep onhand for that:

--BCP to get headers

--Version 1: global temp table

--note i'm making sure my headers...

can't see a reason for the calculated persistent column;

here's my prelim version of your schema, based on what you posted:

by making the column not null, with a foeign key,...

well it looks like it can be done without the cursor and also without the dynamic SQL;

this SELECT is the section that would be doing the INSERT;

how many rows does...

well the details are certainly different now that the DDL is posted.

the DDL details you posted is doing an Insert, not an update, and it's not joining on five...

Charmer (5/29/2012)

---

oh....but i am not sure how...