Hi All, Basically we updated a field size through the Admin Tool. This was a character field. The SQL DB froze up and the job crashed.
So my question is this we have a Z temp field that was created and since the orginal field is nvarchar and the new update makes it a ntext field. Since this Z field is still there and not completing. We are unable to use the field or update the field in anyway. Is there anyway to clean up this Z temp field with out any restore? Running 7.0.1 patch 2 Thanks for you time Tim _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
