Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cfmxguru
Starting Member
3 Posts |
 Posted - 2007-02-11 : 16:59:40
|
| When I use Enterprise Manager to Open Table and Return all rows I have a table that has 2 columns with data in both columns, but one of the columns shows the data and the other column does not show any data. When I use Query Analyzer to look at the data in the table the data is there in both columns.I'm at a lost on this one.Thanks in advance for anyone that can shed some light on to this. |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-11 : 18:26:45
|
are you sure you are connected to the same database in each app?what are the datatypes of the columns?
www.elsasoft.org |
 |
|
|
cfmxguru
Starting Member
3 Posts |
Posted - 2007-02-11 : 19:05:22
|
| The datatype is varchar and yes I'm certain it is the same database. I do that the database was detached and moved to a different physical machine and then attached on the new machine or at least that is what I was told. I have been working with SQL Sever since ver 6.5, I'm not a DBA just a programmer. I have never ran into this before. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-02-12 : 00:47:02
|
well, i would trust QA over open table. I never use open table to be honest.here's a guess: perhaps there are some crlf at the beginning of your data, so in open table the chars don't show up? maybe you see something if you expand the cell vertically (if that's even possible with open table...)
www.elsasoft.org |
|
|
|
cfmxguru
Starting Member
3 Posts |
Posted - 2007-02-12 : 08:49:39
|
| jezemine,That sounds like it could be it. After inheriting this application I can remember finding data like that, padded with spaces or CRLFs. I will have to check that out.Thanks for your help and suggestions. |
|
|
|
|
|
|
Seeing Data in Enterprise Manager