I disagre, the question states that there is "contention".  It says:

you have a number of databases making heavy use of tempdb on your SQL Server 2000 server, which is...

I think there are definitely some great leaders and those that build companies. But lots of business is luck, it's timing, it's taking advantage or being able to take advantage,...

I'm a little torn here. A SQL Server 2000 instance is an instance of a database server. Maybe it's semantics, but each instance is a server. The confusion above seems...

I think it's a great question. If you are presented with any question in an interview it won't be with a complete understanding of the situation. That's why you ask...

It's a bug, but we're rewriting the aritcle stuff, so be patient.

It appears from my testing, that if a create table is in the sproc, the grant execute does indeed create those permissions. I setup a simple sproc to create a...

You only need the SP for the SQL Server for the base product. The MSDE one is for MSDE installations only. The AS one is for the Analysis Services product...

Where do you have to retype the password? In the Services dialog?

Are you picking the account using Enterprise Manager? There are certian rights that it needs that will be setup...

There are pros and cons of both. If you use Windows, passwords are managed for you, users don't need a separate passworrds. However, I've seen some screwy domain issues, can't...

Run profiler and see where the connections are coming from, what IP, hostname, etc. is being sent to the server. Are they all in the same db? Perhaps something in...

I think you have a suspect database if it is flagged in master, regarldless of the databaseprooperty return. Check your error log for issues.

Visual Studio is the best MS tool, but many will work.

VIC-20 here. Tape and all, but I'll see your 64 and raise you an Apple II

Thanks for the comments and I appreciate the thanks. I hope to see Ken soon and give an apology in person as well.

I don't think India should be singled out....

checkdb is recommended. It is a more exhaustive check and if it finds anything, you probably need to call Microsoft.