never seen this in 7 years??

[DOGWATCH]

Did a dts import from an excel sheet and when you
go into Query Analyser highlight the table then choose
open table, all the records show like

(...) (...) (...) (...) (...) (...) (...) (...) (...)
(...) (...) (...) (...) (...) (...) (...) (...) (...)
(...) (...) (...) (...) (...) (...) (...) (...) (...)
(...) (...) (...) (...) (...) (...) (...) (...) (...)


however if you just do a select * from tablename it actualy shows the correct data... so the table ins't really filled with (...) it has real data.

This is just odd, there is only 1200 records in this particular table and it doesn't happen
on the much larger tables in the db only this one. I've used SQL for many years and have never seen this before..

 

[gmmastros]

Try resizing the columns (making them wider).

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[DOGWATCH]

nope that doesn't work.

 

[AlexCuse]

can you post the script for the table involved? I'm with George, I think its' your column width.

Ignorance of certain subjects is a great part of wisdom

 

[mrdenny]

What are the data types of the data. Is the data uni-code?

The table editor window simply font may not know how to show the data.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com