correct me i'm wrong, but you saved this script as a stored procedure, and the stored...

donato, are you trying to usee a CASE statement to return a desired value as a column, or as a WHERE condition?

SELECT

CASE

WHEN ITM.MNR_CD = '100' THEN '15'...

yes; like i had said before, I'd seen the issue in the past. I could never track down exactly what was the cause, but I found that changing that default...

Jeff Moden has a great quote on changing your mindset from row by row to "set based" thinking:

First step towards the paradigm shift of writing Set Based code:

Stop thinking...

i was kind of assuming the update was more complicated...you know 500-1000 might be a different multiplier, for example. there was no good reason for it, other than to allow...

here's my WAG based on your SQL:

UPDATE CP

SET CP.BaseRate = CASE

...

your cursor does not have an update statement...the only thing it is doing is fiddling with the variable @BaseRate i think.

did you forget to add the UPDATE to teh cursor?

WHILE...

I think Jack might have the key right there: Exceeded storage allocation. is mailbox full, right?

alternatively, maybe your server is set for 10 Megs, but the destination server's limit...

you should paste the whole error;

when i googled "error -2146893044"

i found "error -2146893044: The logon attempt failed " in the first 3 links, but it seemed to be referencing network...

SQLServerVBA (7/20/2009)

---

The User connects to the production database. There is only one database that the user connects and all tables & stored procedures are on that database ONLY. So there...

could it be security? does the uer who is inserting/updating into the table also have insert rights on the table in the other database?

maybe these specific statements need EXECUTE...

ive seen this before...make sure that user has a specific default database for his login, instead of master. that database should be whatever database he's using for the application.

i think...

there's a script in the scripts ection for sending an SMS in a trigger here:http://www.sqlservercentral.com/scripts/Miscellaneous/31899/%5B/url%5D

that uses the exisitng email-to-SMS functions that every cell carrier seems to support.

there's a lot of...

two ways...you can use the REPLACE function to replace the bad word with an empty string:

UPDATE MYTABLE SET MYCOLUMN = REPLACE(MYCOLUMN,'BADWORD','')

this is a better solution, because if the bad word...

[ edit doh i think i misread your question; i thought this was related to backups over the network, getting xp_cmdshell to work over network, etc...sorry]

I don't think you can...