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.

If you think this database might not be used, then set AutoClose and when someone accesses it, an entry will go into the error log.

Note that you don't want this...

Please don't delete the post. If you find out the information, post the answer as a response. It helps others learn that might have a similar problem.

Not sure I want to joke about us taking over SQL Server development, they might buy us and make us help! :hehe::-P:w00t: