We've scanned for service accounts, but that might not help with Express/MSDE.

The only good way is to get a list from SMS, then connect to each instance and run select...

Unspecified means there was an error, but no one wrote a handler for it.

You can try a few things. If you can manually run the DTS package, run it against...

Turn it off: http://blogs.msdn.com/sqlserverstorageengine/archive/2007/03/28/turn-auto-shrink-off.aspx

It could cause blocking, but it's a bad idea.

If F is R1+0, I'm not sure that adding one drive and moving logs there helps that much. How much log activity do you see? How many drives are on...

From my understanding, if the query is completely on the remote server, it is passed through (WHERE clause and all). If this is a distributed query, meaning you are joining...

I believe the SQL 2000 standard sees 2 CPU sockets, but the architecture will spread the SQL 2000 threads on 8 cores. I'll ask around and see.

I haven't seen any, but I'm looking for some.

There is one from VMWare, but since they're selling virtual software, not sure how much to trust it:

http://www.vmware.com/files/pdf/SQLServerWorkloads.pdf

You will get some gains as SQL Server is written to be multi-threaded. Something most desktop apps are not.

That can help with internal fragmentation and provide some speed gains.

However, don't shrink the db. That undoes what you do with reindexing.

detach databases, script logins,uninstall, install, add logins, attach.

Is there a date/time field for updates on the source? If so, that makes it easy.

I'd still use DTS. If the table is small, the truncate works fine. If it's...

This is in Control Panel Services. The MSSQLServer service and SQLAgent services are the defaults. Multiple instances will have the instance name listed.

It's in the registry as well. More info...

This help?

http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx

As stated above, this is informational. If you have multiple instances, you should set them assigned ports so they aren't constantly changing. Your network people should know which ports are...

A few possibilities. And if you like one or find another, write an article!!! 🙂

First, allow each developer to create objects in their own schema. So developer Bob would create...