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?

No way I've heard of.

DB2008 is correct.

You can set the ports in the Configuration Manager, or you can let SQL dynamically manage ports for named instances. The default is 1434 for the default instance,...

Ideally you'd do this with a separate server, and test it completely to be sure it's working. A virtual server is a great place to do this.