Leo.Miller and CirquedeSQLeil, thanks for the follow-up discussion; it sounds like some factors depend on your environment and this has helped me know what to look for in mine. ...

Leo.Miller (7/12/2010)

---

Disabled the SQL Browser also adds a layer of security. The browser does a bit more than convert instance name into port number, it also makes it possible to...

Thanks for the advice, folks; I think I understand my options a little better now (I hadn't considered a static port w/ SQL Browser, for example) so that should help...

Dan H. (7/9/2010)

---

One reason I've set our named instances to specific ports is our firewall rules. We want control over over which machines connect to our databases, even if...

Thanks, that answers my question...

Andrew & Hassie, thanks for your comments. Performance isn't a problem for us right now, but it's nice to know what our options might be when the time comes....

Jeffrey Williams (4/22/2009)

---

If you drop and recreate the destination table every time, then you also have to recreate the indexes and re-apply all security to the table. Then, what...

Jeffrey & GSquared, thanks for the procedures and advice. Is it fair to say that the efficiency is primarily due to disabling the indexes, and that it wouldn't make...

Yes, this database user has 'dbo' defined as it's default schema, just as all the other...

Me neither. It just looks weird,...

I vote for option 2: document, then fire.

Sure, his managers have been a bit weasly by not more directly addressing the issue (and should rightly be faulted for that), but...

RPSql (8/7/2008)

---

I have a problem with sql server 2005 maintenance plan for Check Database Integrity task...It is getting failed and gives the error that you have to set quoted identifier...

hill4m (8/7/2008)

---

The SQL Native Client for CU7 is 2005.90.3042.00. I believe in this latest CU, the native client was not changed so you may have already had the latest...

hill4m (8/7/2008)

---

The purpose for them being separate is so that you can install the Native Client update on client machines. We were having some issues with client machines using...

Excellent. Thanks for the reply.

Last follow-up question: I notice that there are two installation files, one for the CU and one for the SQL Native Client. I'm assuming...