hi,

Its working fine after excluding reorganize logic. But I'm running this script for each database one-by-one manually connecting each db. Could you tell me what & where should I add...

Hi Gail,

http://msdn.microsoft.com/en-us/library/ee308910%28BTS.10%29.aspx

From the above Microsoft link:

Default Settings for the Database Index Rebuilds and Defragmentation

BizTalk Server does not support defragmenting indexes. “DBCC INDEXDEFRAG” and “ALTER INDEX … REORGANIZE …”...

http://msdn.microsoft.com/en-us/library/ms175008.aspx

I have used script listed on this page but i have modified it to replace cursor and run it for all databases in production server rather than just one database.

I'm...

I have ran this query in a database "DB_Name" and its returning the tables related to some other database in the same instance.

But how can we check whether all...

I found the below script from MSDN for index deframentation:

avg_fragmentation_in_percent 30 ---do index rebuild

Can I schedule this to run every day after business hours?

-- Ensure a USE ...