Re: Changed field size on a Field

@ARSLIST.ORG Subject: Re: Changed field size on a Field You will also need to alter the T table, to change the length of the field there to actually change the description of the table. Since it created an ntext field, and has still kept the nvarchar you will need to copy the contents from the nvarchar

Re: Changed field size on a Field

before you do anything so you have a recovery point in case we missed something..   Joe - Original Message From: Hall Chad - chahal <[EMAIL PROTECTED]> To: arslist@ARSLIST.ORG Sent: Tuesday, September 23, 2008 10:02:50 AM Subject: Re: Changed field size on a Field You should be a

Re: Changed field size on a Field

ystem discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Timothy Rondeau Sent: Friday, September 19, 2008 9:07 PM To: arslist@ARSLIST.ORG Subject: Changed field size on a Field Hi All, Basically we updated a field size through the Admin Tool. This was a character field. The SQL DB

Changed field size on a Field

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