One sql server is located in Wisconsin and the other is in South Carolina, the logs ship every 15 min and aren't usually larger than 100 mb. The problem I...

I did some additional testing and it seems like it only sends twice when there is an external email address listed. I then checked the mail log and see this...

There are multiple records listed in this table for the same message which have corresponding sent times that match the emails I received. The send_request_date is different for the 2...

I don't quite understand what you are asking. Can you give me some insight in how I could look into that? I get copied on all the emails that are...

Nevermind, I see it. Thanks for the help that seemed to work.

Gail,

I'm not sure if I'm missing something but I don't see a difference of what you posted as compared to what I did.

Jason

GSquared (10/11/2011)

---

If it's that complex, a loop through the inserted table is probably the best bet.

But I can't imagine what running a 2000+ line proc on each row of a...

The VM server which hosts the SQL VM did not show any processors at 100% while the SQL VM was showing all 4 processors at 100%

I did update stats and...

There are 4 cpus and 4 gigs of ram assigned to the VM. The VM Host is a Quad Dual Core with 32 gig of ram. The 100% CPU ussage...

When we turned off SQL Server Service the server did drop down to minimal CPU ussage(under 10% max).

All of the services were intitally installed with sql 2005 running service pack 3. Windows is 2003 Standard addition is fully patched as well. After the inital testing we turned...

Mayank,

The database is about 2 gig in size. We take full nightly backups of it both with backup exec and i run sql backups to a NAS device. We...

Gail,

I have run the check db in Query analyser with the database selected that is showing in the error message and it returns nothing I have also...

Mayank,

There is nothing in any event logs but the Torn page/ bad page id errors. I check sql, system, application and security and there is nothing besides the message...

Gail,

I get these Emailed during the day and run the check db within 5 min of the error. So far today I have gotten 11 of these errors. But everytime...