John Mitchell-245523 (12/2/2010)

---

How do you know that the individual column used 100GB?

It could be that deleting the column freed a certain amount of space on each data page, but that...

Forgot to mention, tried that one too..:(

Thanks Gail. I am really anxious to find the root cause, let me check with Microsoft. Thanks

Paul Randal (11/30/2010)

---

Hmm. Anything that causes stats corruption is a bug in SQL Server. Did they mean some SQL query is causing the corruption? Are they investigating the bug? This...

Paul, they haven't mentioned in the email but they did say verbally that some of the process from the front end has corrupted the stats. We have seen a similar...

Thanks Paul. Mentioned below is the statement from them after analysing the sql dumsps

"On further analysis we found that we were trying to get the Average length of a set...

GilaMonster (11/29/2010)

---

Index rebuilds can easily cause corruption (normal corrupt pages) to disappear as the process of rebuilding deallocates the damaged page. I'm going to consult an expert on corruption as...

Thanks everyone. Mentioned below are few more details on the issue and the solution.

i) We started noticing sql dumps under the log folder with these messages "A system assertion check...

Thanks Janis and Rozema.. I will try this and let you k now

If you know the time interval run sp_who2 every 2 minutes and capture the logs. It should give you some info.

rhamnusia (11/22/2010)

---

Jeffrey Williams-493691 (6/15/2009)

---

iqtedar (6/15/2009)

---

I would say the best option is to install litespeed and use it. I believe the trial version can be used to restore backups even...

Hello...

this works. Thanks

janis.l.murphy (11/22/2010)

---

If the stored procedures being called include metadata from INFORMATION_SCHEMA.ROUTINES in the RAISERROR, they should return the desired results.

CREATE PROCEDURE usp_ErrorTest

AS

DECLARE @ProcName nvarchar(128);

DECLARE @RoutineCatalog varchar(128)

DECLARE @RoutineSchema varchar(128)

SET @ProcName =...

not sure what you mean