Whichever you are more comfortable with. For your own work, or with a small group, I don't think it matters much. For 2005, since most things are SMO NET assemblies,...

I wish I had a full fledged test system. Maybe I should ask Andy and Brian for one for Christmas next year

Insert it like any other field at first. To update/rewrite, you'll want to search on this site for WRITETEXT.

If you use with TRUNCATE_ONLY, you need an immediate full backup.

This is difficult to do in T-SQL. Recursion is an option and works well in 2005, but I'm wary of it in 2000, plus you might hit a nesting limit.

Check...

Ah, many people use multiple publications and it works well. Andy has a large box with over 200 dbs, and runs quite a few replications from one master db to...

http://www.sqlservercentral.com/columnists/sjones/atemporarymove.asp

Didn't see the Montana game, but yeah, that stings.

Brett Favre's win might have been mine, but I didn't see that one either.

Apologies. The original question was changed later by the submitter and I was supposed to switch around the answers. I've added back points for 3 and 4 answers.

osql from the command line with a script might be easier, but it's not T-SQL.

I think it would help, but are you talking about using other servers? Not sure you can have multiple publishers on one instance.

Agree. Call PSS and don't mess around with this data.

Let us know how it works. I put it on my laptop, but a little chicken to put it into production

Indeed. I'd think if you got over 10k tables you'd be asking for trouble.

You might have forgotten users. Search sp_help_revlogin on Google for the script to help you move users. It's an MS KB item.