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.

You'll have to provide more information about what you did. Make sure the table name and schema is correct, and that the user has permissions to see the table.

TheSQLGuru (6/3/2009)

---

One exception I will take to what you said: "Someone that's worked with SQL Serve for years learned a lot about the platform, what works, what doesn't, and...

Feeling OK today, not last week. I think the final edit and podcast affected the writing. My apologies.

Simple mode sounds good for you.

The transactions are in the log file until the checkpoint, which is about every few minutes. Depends on load.

The log files can grow if there...

I posted that one on Twitter. Wonder if anyone else has a better way to explain it.

Popup from a trigger is a new one on me.