see of it helps you

http://www.sqlservercentral.com/Forums/Topic489120-149-1.aspx

We can give manual run to ALTER INDEX...

Very nice post

pshaship (3/9/2010)

---

Declare @DBName varchar(50)

Set @DBName = 'YOURDBNAME'

Select Db_name(ps.database_id) as DBName,object_name(ps.object_id) as TableName,I.name as IndexName

,sum(isnull(ps.avg_record_size_in_bytes,0) * isnull(ps.record_count,0)) as IndexSizeBytes

...

try this DECLARE @Ranges_1 TABLE (

[ctr] int identity ,

[Id] int NOT NULL,

[varchar](3) NOT NULL,

[dos] int NOT NULL,

[paid] float NOT NULL

)

INSERT INTO @Ranges_1 VALUES (1, '123', '20', '10.75');

INSERT INTO @Ranges_1...

Saravanan_tvr (3/10/2010)

---

I tried here its working but takes too time...

Select sum(stock1),

(Select sum(stock2),item_no from table1

where date = '2010-01-02' group by item_no) as [stock on hand],

item_no...

sinamora (3/9/2010)

---

Day1 Day2 Day3 Day4 Day5

12 3 ...

You should need to review the error log file...if any database in recovery mode then you might get this error. if you can post the error log file where you...

Post your table and index definition along with exec. plan

Read below post

http://technet.microsoft.com/en-us/library/ms191284.aspx

And why we require to do it

http://support.microsoft.com/kb/873235

Are other jobs running fine ?

can u using the same (this job's)account for...

Thanks:-)

can you...

Run your job with the same accounts which is being used to run sql server agent.

YOu should post Sql server 2008 related question on sql server 2008 tabs.this is for sql server 2005 😛