From BIDS or VS you save a copy of the package to the server. You can then execute the package via DTExec and DTExecUI, or as a step in a...

Run a search for Chinese collation sort in the BOL. Sounds like the collation in the database could be presenting a problem. Hope this helps 🙂

196 Chinese_Taiwan_Stroke_BIN

197 Chinese_Taiwan_Stroke_CI_AS...

If I'm understanding you correctly, I think your looking for a case statement - i.e.

update myTable

set column3 = case

when column2 like '%thisvalue1%'...

NP 🙂

This sound like a good candiate for SSIS. SQLIS has some good examples, ie.

http://www.sqlis.com/55.aspx

What I was suggesting earlier is that you save this query as BLAH.sql and use SQLCmd to...

Ok, I'm not sure I understand your question. If your attempting to execute a SQL script from the command line, you can use SQLCmd (i.e. calling SQLCmd directly, from a...

SQLCmd - http://msdn2.microsoft.com/en-us/library/ms162773.aspx

This white paper which details how to configure Database Mirroring in SQL 2005 for SPS and WSS 3.0 - http://go.microsoft.com/fwlink/?LinkId=83725&clcid=0x409. Might help 🙂

I'm not sure I understand your question - are you just looking to create a table for your select statement? i.e.

create table #BLAH

(VIOLATOR varchar(25),INCIDENTDATE datetime)

insert into #BLAH

select VIOLATOR, max(INCIDENTDATE) AS...

Good luck 🙂

Try -

DBCC xp_availablemedia (free)

GO

message box = assuming of course your using it for debugging purposes. Not really sure why else you would need it 🙂

What sort of problems are you having? The very first step I recommend in troubleshooting any SMTP related issues with database mail is to first confirm you can send mail...

We've been running build 3186 in production for a couple of months without any problems. Cumulative update 4, build 3200 is the latest build available (http://support.microsoft.com/kb/941450/).

To the best of my knowledge it works a a series of small system transactions so there really is nothing to rollback. You will have to start over however 🙂