You'll never stop 'cheaters'. First you need to define what a 'cheater' is.

Is it a person who waits until the answer comes out and then sends in their response?

Is it...

Easiest way to check mccork's suggestion...

In EM, drill down the databases. Right click on each database and select properties. Go to OPTIONS. What is Recovery Mode set for? If it's...

Okay I'm wrong. That's the answer for MSDE version.

This is according to Microsoft's Web site.

Up to 4 Processors

Up to 2Gb of Memory

Maximum Database Size 1,048,516 TB

The 2GB of Memory is...

Neither. It's the maximum size of the database.

-SQLBill

quote:

---

The point I'm trying to make is that QOD could become quite a useful method of seeing whether you are up to...

The first thing to check when you have a new job fail is; what is the response when a job succeeds?

Using Enterprise Manager, drill down to Jobs. Click on the...

You COULD create two log backup jobs. The first one (12:45) would use the command WITH INIT. Then a second job that would run all the other log backups and...

The problem with the solution in Frank's link is that you have to have a current post showing or be willing to go through a whole forum to find one...

I did post, in the Suggestion forum, the question about there being TWO General forums. Turns out they meant for one to be General SQL Server questions and the other...

guarddata,

You are right, at times there are several viable solutions.

What I was intending to do was let everyone know this was a double post and the other post had been...

Dale,

You are WONDERFUL! I never noticed that option. It is what I was looking/asking for.

Thanks for pointing it out to me.

-SQLBill

Steve,

That's fine and it was just a suggestion from me.

I've only see the option on one other site that I go to. If you want, check out http://www.tek-tips.com it's free...

I for one don't really mind seeing the adverts. I agree, that's the price you pay to get something free. I just ignore the one's I've seen before.

I just dislike...

Nope. Another site I frequent has a link:

My Threads

If I click on that I get a list of threads that I have either started or posted to and the title...

I suggest a slight name change:

General - SQL Server

General - Programming

Although I do like Andy's option.

-SQLBill