This was fixed today. It was due to a missing Security Group in Active Directory.

Those were the exact steps I followed. Hopefully today is a better day....txtPost_CommentEmoticon(':-)');

The min server memory server configuration option can be used to ensure that SQL Server does not release memory below the configured minimum server memory once that threshold is reached....

That did it, Thanks again.

That is what I'm looking for. Not thinking. Thank you very much.

Alan - Thank you very much. This did the trick.

Thank you! This looks like what I am looking for. I will test it out in the morning and let you know!

My apologies if I was not clear.

Select @v-2= var From db..tab1 Where col1 = @d1 and col2 <> '*'

If in tab1 has a character which I...

Yes, it was the brackets. Thank you!

Thanks man!

Will backup_finish_date = NULL if backup is in progress? I would still need to loop in case it's still running.

Its part of a procedure. After backup completes, I want to start deleting records from a table. But do not want to start the delete until I am...

Thank you for the replies.

After getting the green light from my boss, I ripped out SQL 2008 yesterday and installed SQL 2008 R2. After the installation, SQL is now seeing all 80 CPU's....

Thank you! Now let me put it to the test!