Chris,

I tend to agree with you. Most IT groups don't want to upgrade servers often. But they will look to new versions, and I think it's a good idea to...

The ADO interfaces should be backwards compatible, but you need to test. You cannot do this migration without testing your specific application against a 2008 server.

It depends on the OS and edition since those have limits. If they listed each one, then it would be a much more confusing chart.

Web reference: CPU and memory

I agree with Jack's list.

ALTER INDEX is typically the first one, DBCC the second. The maintenance plans list these if you walk through the options, it will somewhat explain what...

Don't grant users any rights.

Create a role(s), and then add users to the role(s). Grant EXECUTE on the stored procedures to the roles. That's it.

You do not need the views...

CONTROL allows you to change things. http://msdn.microsoft.com/en-us/library/ms187940.aspx, CONTROL almost makes the like an owner.

No one gets permission by default. You do not need to check DENY, unless the user is...

Yes.

As you restart SQL Server, errorlog becomes errorlog.1, .1 becomes .2, etc. and a new errorlog starts.

Same for agent.

I agree with Gus that you don't want to be moving the size around. Why were you shrinking it? Is 100GB too large?

Look at your log backups, find the largest...

You might have VLFs (virtual log files) that prevent shrinking at times. There's a Forcibly Shrink the Transaction Log script on this site that can help.

HOWEVER, you should not be...

Chris,

It's a balance and I'm not sure how to address it. Microsoft doesn't expect, in my mind, everyone to upgrade to the next release. What they likely think is they...

DB2 has come a long way, and in many ways Oracle has as well. However I know plenty of DB2 and Oracle installations that heavily depend on command line work,...

But, Buy, I was close. One letter away on the keyboard.

Jeff, check the MVP offers (private newsgroup). I think SQL Mag will give you a free sub. Heck, you've earned it.

Never read it, but if you contributed a story, I'll buy a good priced version.

I signed up.

It's customary to post what was wrong and what you did. Someone might need the information to solve their issue.