Thanks and we'll consider this. Sometimes it adds a lot of work to explain or create references for wrong answers, but I'll see if I can get better.

Robert,

Congrats on the new job!

I definitely fight that lack of people. My wife is usually here, but weeks like this one, where she's gone all week, are lonely and hard...

Comparisons usually require a line by line marking and T-SQL isn't good at this.

Word does this if you select the "Track Changes" menu item. This works pretty well and you...

You should get the Express Edition of SQL Server with VS and I don't think it includes SSMS.

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?