Anyone have problem with Upgrade to SQL Server 2005 and Blob fields?

[sonname]

I have been upgrading some of my SQL Server 2000 databases to SQL Server 2005 by doing a detach and attach of the mdf file. I have noticed that sometimes, tables that have Text or image type fields become corrupt. This is confirmed by running a DBCC checktable. It does not happen on all tables with these data types, just once in a while and it is not always the same table either. Anyone else experiece this?

 

[NoCoolHandle]

What happens if you run dbcc check db on the in the 2000 system?

Did you check it before the detach/attach??

 

[sonname]

Hi,
I did check the table in SQL Server 2000 before the detach and it was fine.

 

[NoCoolHandle]

wow... I have never seen that yet .. but i guess I can expect to at some point.

Did you try detach and reatach to the 2000 instance? If so did the error still show up?

 

[SQLDenis]

I Don't use BLOBs so can not have a problem ;-)

I do know that text and ntext are replaced by varchar(max) and nvarchar(max)in SQL server 2005
text and ntext are being deprecated

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions