thanks a lot Dan and Lowell for replying on this.

Dan, I am trying to find if there are any other things running against the same DB.

Lowell, Report is running with...

Thank you so much for reply.

Currently, I have SQL 2005 SP3 +CU1 installed (version is 9.00.4207). I need to install ms09-062 which is critical patch so wanted...

thanks for your response Meredith! That's true.

thanks a lot for the response by mistake I copied the other error. Below is the correct error details

The index "d_1f3b03c58002" (partition 1) on table "sdm_text" cannot be reorganized because...

Hi Andy,

This is bug in SQL 2005 which has been fixed in SQL 2008.

Thanks

SNT

Hi Andy,

This is bug in sql 2005 and same thing has been resolved in SQL 2008

thanks

Shriniwas

Hi Andy,

If you seperate your DDL and DML transaction then it works. Not sure if there is any fix for this post SP2 release since this was working in SQL...

Hi Andy,

If you seperate your DDL and DML transaction then it works. Not sure if there is any fix for this post SP2 release since this was working in SQL...

Hi Andy, Did you get any solution for this?

If you keep DDL and DML in seperate transaction then it works.

Please let me know if you have got any fix.

Thanks in...

XA transaction is enabled in the MS DTC security

thanks for the reply.

yes, I am using NT/Network Authority account

--SNT

Thanks a lot for the quick reply Matrin & Sugesh.

Martin, I am able to connect the SQL instance using "management studio" but only after giving the port number like server\instance,1433. Without...

thanks a lot for the information.  do you know the exact path?

I can see EE evaluation, SQL server trial etc for the downloads but not the 32-bit standard edition.

Thanks for the response. 

I will check if the drop/rebuild catalog resolve the issue.  Issue here is FT service is offline so need to clean from the registry manullay

thank you so much tosc!  it worked