You don't want R5 if you have many writes. (http://www.baarf.com) Go with R1 or R10, be sure that you have separate arrays for data and backups.

Any of the major vendors...

Is the linked server set up to pass through credentials? Or impersonate?

How is ISS configured? Is it passing through NT credentials?

http://www.sqlservercentral.com/articles/T-SQL/66030/

I assume you mean in querying. You can't determine which page in the server data is stored on.

Please don't post the error in the title. We can't see the whole thing.

SSPI handshakes are AD errors between your server and the domain controllers.

Please don't use the subject or title as your question. Post the error in the post.

SSPI errors are security errors between the service accounts and the domain controllers.

I'd disagree. You don't want to set this on databases that are being used, but if you suspect that there is a database not used, or rarely used, I'd set...

At least not to his boss :w00t:

I'm with Lowell, you really want to look at this. Granted, it might cause some development issues, but it might make things work better down the road. Be sure things...

It's a bit of a mess and you'd have to decode the sysschedules table. I've seen some scripts try,but nothing that works great.

Might want to check out SQL Sentry's product....

Manie,

You reminded me of a time, years ago, when I was working for a power company. We handled the Novell network, DOS/Windows 3.1 clients, computers new to people (90/91). One...

I'm with Gail, don't put staging tables in there.

Create another filegroup on a new disk, or a new database to hold staging data. Tempdb is for temp working space that...

The upgrade advisor should help here.

You ought to look at 2008 instead. Same license cost, longer support, about the same compatibility as 2005 with 2000.

I think most of the virtual products can create a VM from a physical installation. HyperV has this as well.

The question was edited to note 2005.