You might start here: http://msdn.microsoft.com/en-us/library/bb500348.aspx

It's worth understanding how this works before you set it up. It's pretty simple to set up with the wizard, but you want to know what...

Bruce,

Go for it. We're always trying to get some done, and it's a struggle. Get a good series going, and it might even turn into a book!

The enforcement should be based on the base OS.

If you are working with Windows Auth and SQL Auth, there're not related.

That would work, but you'd switch your then and else clauses.

There is some info here, http://www.sqlservercentral.com/articles/SQL+Server+2005/64547/, but you you do want to set up auditing if that is an issue.

By default, only a limited amount of information is captured.

Please post int he appropriate forum. There are forums for 2000 questions. Moving this thread.

You would need to use SQL Agent to schedule this as well.

If you read up...

Virtualization definitely can, and I wouldn't be surprised to see more of this.

You can cluster two virtual servers as long as they can see the same shared disk. So the...

Lee,

Thanks for the update, and that is strange. I wonder if there is something weird in the XML file that contains the configuration.

Perhaps some weird connection string thing?

Very interesting. William, if you go down to 10GB, I'd be curious to know if that helps.

Also, SQL will give up memory, but painfully, and slowly. It doesn't like to...

I thought that 12GB should be fine for a max there. This is 64bit, so there shouldn't be paging of RAM in and out of the 4GB space.

What is requiring...

The jobs forum redirects to the job placement thing on the left side.

I'm tempted to whack that since there isn't a lot of traffic.

Opinions?

I could send you some numbers Eddie,...

I used them for a 2005 exam, not sure if it was 06 or 07.

Are you sure there's free space in there? Perhaps there are temp objects preventing it from shrinking?

Supposedly the All-Access is slightly above the cost of 2 tools. What that means, I'm not sure, but check it out.

If you have a separate question, please start a new thread.

Otherwise, your post does not make sense. What are you looking for?