edited after poutting foot in mouth:

i had thought just like you that the stored procedure sp_changeobjectowner should do what you want;

but the article you mentioned states if it's in...

yeah...still two statements, you really didn't give enough info to help, but here's a lame example:

--only matches will get updated, right?

UPDATE TABLEA

SET PROCESSFLAG='Y' WHERE PROCESSFLAG='N'

FROM TABLEB

...

it's kind of easy...you use a SUM() of CASE statement to logicilly decide whether you want to add the values or zero:

select * from #Conditional

select sum(CASE WHEN VALUE BETWEEN...

no, it'll be two separate statements....but that's not a bad thing.

can you give more details what you are trying to do?

this is a very common situation, where you update existing...

ouch...without dynamic sql, and still trying to do it in SQL and not a programming language, I don't know how you'd be able to do it.

the headache is the max()...

4194840 = TORN_PAGE_DETECTION,OFFLINE,AUTOSHRINK

528 = TORN_PAGE_DETECTION,OFFLINE

my script from page one helps find the values, here's a snippet where i just plug in specific values:

declare @status...

jacob hit the nail on the head; chances are , if you can post the trigger here, we can show you how to re-write it so it handles multiple rows...

I've only got the Express Edition, but the logic to get the data out should be easily adaptible.

you want to use a CASE statemnt for each of the variables; "&",...

like Glen said, changing the Server collation does not affect any databases, nor the individual columns that exist int he database...you need to handle those seperately.

Server collation...

each database collation...

Each column...

found this specific citation; 2005 and 2008 have the same maxes for this

http://msdn.microsoft.com/en-us/library/ms143432.aspx

SQL Server Database Engine object ...

doh i didn't even see that CR might mean Carriage Return Line Feed...goodjob...

Like Hanshi said, you might want something like

REPLACE(TblC2.strAddr,'~~',CHAR(13) + CHAR(10)) as your expression

are you looking fto simply REPLACE of ~~ with CR? or is it more complex than that?

SELECT TblC1.Client AS Expr1, REPLACE(TblC2.strAddr,'~~','CR') AS Expr2

FROM ...

it depends on what you want to do, of course....say that if it's 7 characters, do you you do anything at all? do you only strip off the first character,...

the issue you are running into is the account SQL server is running under is not an account that has access to teh network. jobs run under the security context...

a combination of using substring and a where statement will do the job; you might need to tweak the WHERE statemtn...are you sure it's only items that are exactly 8...