Warning: The average disk queue length is 6. The disk may be at its maximum transfer capacity due to throughput and disk seeks

I assume this is related to the...

I set up a data collector on the Reliability & Performance Monitor last week. I didn't know what I was doing, but I do get results indicating low memory....

I ran DBCC CheckDB(SFIData) WITH No_INFOMSGS, ALL_ERRORMSGS

and got 'Command(s) Completed Successfully'. Don't that beat all?

On Fri 1/14 we got the Event 824 message. We renamed the most current full backup so it wouldn't get copied over and ran a new full backup. ...

We're running SQl 2008 R2 on a virtual server (WIN server 2008) and I dont' see the "Messenger" service under services. If someone found it using this scenario I...

Outstanding! I'll research the trace and play with it. I just started this job 4 months ago and found there is a lot of stuff broken. ...

I'm not familiar with setting up a trace file. Will it reveal records (or gaps) which have been deleted via SSMS (or Enterprise Mgr)?

I know I could have our...

Your second sentence just sunk in with me. I think I had a "duh-huh" moment. Talk about over-complicating things. You're right. This is probably the simplest,...

Yes, my first attempt was on a temp table of sequential numbers comparing to the live table.

The only reason it matters is because I'm trying find out if a...

Thank You very much! My code is obviously errant and I'll have to fix it.

I appreciate all the responses. I used WayneS's suggestion and added 'dbo.' prefix to any mention of a table (or procedure) and that did the trick. I will...

This has been resolved. We changed the actual server name to it's IP address and added the relevant login info.

I installed CE 2.0 on the new server, but it tells me IIS is not started, but it is. Any thoughts?

Jack, Thanx for the reply. I"ll try to work with this, but I won't know what the values of the variables are. I'm reading them from a table.