In addition to Jared's sharp analysis, you are updating every row, even if the values are the same.

if there was an index on lnhist_acct_nbr,lnhist_appl_code,Other_Flag_50 my sample code below might...

to continue on what Steve is saying, a hashed password is never unencrypted to it's original value.

what happens is a potential password is hashed,and the two hashes can then be...

scripting options is what you skimmed over; there are lots of stuff you can turn on and off:

I read your question completely wrong. Manie; Anthony read it correctly.

offhand, getting it in might be difficult; it's just like sending a mail from home versus sending it at work;...

don't believe so; the hash(encrypted binary actually, i think?) of the password is compared to the hash that is stored in credential for the login associated in the sys.server_principals view,...

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....