You are right ,i have excluded one condition and the query and report worked .right now i am using test database looks like i need to refresh it.

after refreshing from...

I am not getting any data even if i run the query in SSMS.

I got it.

Thanks Nelson.

No,i did choose microsoft access but i can only see Datasourcename and description ,and when i am done OK button is populated.

when i tried to set up an odbc hook it didn't ask me to provide login name and password .

Thank You .I got it.

Here is the problem my fragmentation does not change Since i have many small tables even if i rebuild the indexes (if you look into my previous posts you...

Hi ,

I want to schedule this query which rebuild indexes based on fragmentattion and the Database in the query gets updated daily at 6:00 AM.Since the database has...

I am sorry for that....

With small tables you tend to get more mixed extents which may not be able to be totally removed. Remember that SQL Server stores data in...

So ,can i proceed with the script below by just un commenting Page_count>25 in where clause and updating it to 27 since it is not effecting performance anyway(and i am...

Hi every one,

After running the script(to rebuild the query based on fragmentation ) if i run this again:

DECLARE @dbid smallint;

SET @dbid = DB_ID();

SELECT

[object_id]...

Thank you very much for all the replies..........

Thank you

Ok i got it since the fragmentation is above 30% for clustered index it is rebuilding it .As i mentioned earlier this table has non_clustered index too and...

Hi ,

I did try it on dev and test and it ran good .i am attaching the results..

Based on results:

1.In excel spread sheet one that is marked in pink...

So ,does this means i can proceed with this script eventhough my DB compatbility is Sql Server 2000(80) and Query is based on SQL Server 2005?