I figured if I was in your shoes, I'd rather reconsider the potential ramifications of potentially (granted, I haven't seen your app or db) problematic design now rather than when...

You can't use a variable name to reference the tables/triggers. You'd have to parse it in using dynamic SQL.

My concern is, however, that usually having to disable triggers like...

SELECT ... INTO ... requires more locking as well as procedure recompilation in my experience. In my experience, you should explicitly create the table first and then populate...

Look up string concatenation in books online.

It looks (from the example provided) you just want to do an upsert. I would recommend that if that's what you're trying to do, using the method described here:

Try converting them to varchar first...

Well, I've heard two sides to this. On one hand, if everything's on the SAN anyway, you've already got a certain number of disks working for you. However...

Do a case statement and substitute out the 1/0 for the checkbox values in wingdings. Then set the font of the box to wingdings.

You're going to want to dump it into a temporary table, table variable or if possible change the stored procedure to be a table-valued function (not always possible). Then...

You can't, to my knowledge. If I recall correctly (and I'm sure someone else can probably input more here) when you elect to create a new log it alters...

Well, I'm of the opinion that you shouldn't fail-back until you've confirmed that everything is fine on the server; so I'm not a huge fan of automatic fail-back. You...

Well, one way or another the witness thought there was an outage and initiated failover.

One thing to think about is that mirroring is VERY network dependent. You...

I think what you want to do first is identify all the indexes on the secondary data file and rebuild them onto the primary data file. Then you should...

Those are statistics, not indexes.

I'm not sure I understand your situation. You already have copied out all the data and now want to empty the table but leave it there?