February 16, 2009 at 2:47 pm
Hello,
Hope someone can help me. I have a sql 2005 standard database with varchar data in some tables. The data is no longer readable ex. þjxŠŒY’³ýƒŽ~7ʨΠ9#’’v5L,ÝJž was once a patients name. I've never experienced anything like this before, and don't even know where to begin to look. This database was once a sql 2000 database that was attached after a crash to sql 2005. As far as I can tell there is nothing else wrong. Any help would be appreciated, thanks.
February 16, 2009 at 2:57 pm
Can you run the following command and post the output? You may have corruption.
DBCC CHECKDB (yourdbname) WITH ALL_ERRORMSGS, NO_INFOMSGS
Thanks
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply