actually, I meant to say it does not show 255 char, varchar is still the type, but when highlighted, it shows LongText

It work in the sense that the varchar was not employed as field/column type, but now this error appears. It just goes to show you Jane...!

This field contains text...

Using DTS Wizard, I followed the process of setting up which tables that I wanted to export out of SQL and into an Excel spreadsheet. I chose Visual Basic...

I am using the DTS Wizard. I am pulling in the worksheets from Excel and the Wizard is assigning fields by column and then is some how setting the...

This is an interesting fact. I cannot check it now without recovering to a second server, which I don't currently have available (all my extra servers are now dedicated...

Thanks! I have reviewed these and feel comfortable with how to proceeed. I really am looking for why the auto gorw failed since the grow size was small.

This is the error message from the event log:

5144, Autogrow of file 'VBBridge_Data' in database 'VBBridge' cancelled or timed out after 40000 ms. Use ALTER DATABASE to set a...

Thanks to all of you for all of your input! As it turns out the person who posted what he had done has since retracted that statement and has...

I should note here that this is an SQL2000 database

To be precise, the solution of running the start ... settup.exe .. SQLCOLLATION=SQL_Latin1_General_CP1_CI_AS to rebuild the instance.

I tried this solution to change my collation from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS and it did not work. I did not get any errors, but it did not work nonetheless....