Feel glad to be of any help.

Do u see any other errors in ur event viewer relating to your I/O problem?

May be there is problem in ur hardware or maybe device driver .

In ur event viewer...

I found this on net, to calculate size of index in ur database(for all tables).

select objectname, index_size = LTRIM (STR ((CASE WHEN usedpages > pages THEN (usedpages - pages) ELSE...

sp_spaceused TableName

will give u size of the index of the table

I did like this article by Sanjay Mishra about calculating index size:

download.microsoft.com/download/D/9/4/D948F981-926E-40FA-A026-5BFCF076D9B9/TEMPDB_Capacity_Planning_Index.doc

I usually follow rule of thumb that in order to built an index, it will take 2.2 times the...

Also I am guessing whether u have column with NULL values, in that case Aggregate functions will give u incorrect results. I fu do have isnull columns then u should...

venkataramanis (1/8/2008)

---

Paul thanks for the understanding.

Ldf file will get increased during reindexing but in my setup .mdf file also getting increased.

I like to know the reason why mdf file...

48000 MB = 48 GB

what messge do u get when u run this command on ur backup:

RESTORE VERIFYONLY FROM DISK = 'C;\BlahBlah\urDatabase.bak'

where 'C;\BlahBlah\urDatabase.bak' is location of ur database.

Its nothing to do with the error...

Thanks Guys

nice

so if for a particular State = NULL ,count(status)>1 only 'Active' status row should be displayed or any status row can be displayed('Active' or 'Pending').

Transaction cane be commited if u use commit tran on the same SPID or client that had started executing your T-SQL queries. (i.e. same window)

Opps I am sorry u have to add this in the code too

EXEC(@tsqlalter)

--after the

SELECT @tsqlalter = @AlterTable+@AddColumn+'money'

so it should be

SELECT @tsqlalter = @AlterTable+@AddColumn+'money'

EXEC(@tsqlalter)

Above transaction will result in Deadlocks. This current SPID will allways be in a running state until commited or killed.