My business partner, Brian Knight, can build a cluster in an hour. I'd expect you can install SQL Server in a cluster easily in under a day. Maybe a day...

Perhaps you could also show the code you're running and explain what you're trying to do. Just showing error messages doesn't really help. Would you ask someone a question like...

I'd also look at the Inside SQL Server book on queries. That will help with tuning.

Can't add any more data to tables on that file.

I tend to agree with Andras that there may be a better way to do this other than a trace.

Second vote for Toni's solution. Maybe script this as part of the database creation or restore)

Sometimes those things are true, but not always.

It can limit your ability to advance. Many positions as you go up in the company require that you be at the office.

It...

Everyone please take a step back and calm down. I don't think Jeff meant anything, but everyone please discuss the topic only.

It's executed as the SQL server Agent logon. So it's not the console where you logged on, it's a separate console for that user.

Even if you use your use ID,...

Get the list of requirements from the Microsoft site and go through them. I know it sounds silly, but those items are covered on the exam. Buy a book as...

That is very strange. If you create a new proc, same code, including the cmdshell, does it work?

All the ones I know about cost money.

Programs -> Microsoft SQL Server 2005 -> SSMS

Be sure you installed client tools. This is not required, so if you don't have the group, run the install again and just...

I have friends with Virtual SQL Servers (under vmware ESX) on blade servers. not sure if these are HP or IBM, but they are SAN connected to avoid IO issues...

I don't trust block level, and here is why.

Suppose I have a large transaction and it updates blocks 1-100. In the middle, I have a failure and blocks 1-99...