Tip – bts_RebuildIndexes BizTalk Databases Bug

When running bts_RebuildIndexes on BizTalk Server 2006 an error will be encountered similar to the below.  This is because the ‘TrackingData’ object was a view in BizTalk Server 2006.  Comment out "DBCC DBREINDEX (‘[dbo].[TrackingData]’) WITH NO_INFOMSGS" in the stored proc on BizTalk Server 2006.  See MS Support for more detail, here.
 
Msg 5239, Level 16, State 1, Procedure bts_RebuildIndexes, Line 4
Unable to process object ID 674101442 (object ‘TrackingData’)
This database consistency checker (DBCC) command does not support this kind of object.
Advertisements
This entry was posted in BizTalk Server. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s