em displays binary data

Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
Dan D.
Use Query Analyzer for viewing data.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
Dan D.
|||I mean, use SELECT statements in Query Analyzer, to view data.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
Using SS2000 SP3a. When displaying data from a user table in EM, instead of
the actual data displaying, the word "binary" will display.
How can I see the actual data?
Thanks,
Dan D.
|||We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:

> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>
|||Could you check the datatype of that column, using sp_help (from Query
Analyzer), and see if it is any different to other databases.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
We have 7 SQL Server boxes and what I'm describing only happens on one
server. I want to fix the problem. Do you have any ideas on how to fix it?
Thanks
"Narayana Vyas Kondreddi" wrote:

> Use Query Analyzer for viewing data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead
of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>
|||I understood what you meant. And we do usually use the QA.
Thanks,
"Narayana Vyas Kondreddi" wrote:

> I mean, use SELECT statements in Query Analyzer, to view data.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:27FE850B-74C6-41A2-B51C-B929B5FA715D@.microsoft.com...
> Using SS2000 SP3a. When displaying data from a user table in EM, instead of
> the actual data displaying, the word "binary" will display.
> How can I see the actual data?
> Thanks,
> --
> Dan D.
>
>
|||Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:

> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
> of
>
>
|||Then, I am not sure. Haven't seen that before. Have you searched KB for any
known issues? My last option would be to reinstall the client utilities.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Dan D." <DanD@.discussions.microsoft.com> wrote in message
news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
"binary" word. I had this happen on my local box once but I can't remember
how I fixed it.
"Narayana Vyas Kondreddi" wrote:

> Could you check the datatype of that column, using sp_help (from Query
> Analyzer), and see if it is any different to other databases.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:1AC2C424-CDE6-4303-A817-DCA79AB700B6@.microsoft.com...
> We have 7 SQL Server boxes and what I'm describing only happens on one
> server. I want to fix the problem. Do you have any ideas on how to fix it?
> Thanks
> "Narayana Vyas Kondreddi" wrote:
> of
>
>
|||I've been searching kb and the web. We're going to reinstall and see if that
fixes it.
Thanks
"Narayana Vyas Kondreddi" wrote:

> Then, I am not sure. Haven't seen that before. Have you searched KB for any
> known issues? My last option would be to reinstall the client utilities.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "Dan D." <DanD@.discussions.microsoft.com> wrote in message
> news:01BCB015-3A5D-4545-A652-5C1D4400CFAC@.microsoft.com...
> Sorry I wasn't clearer. It's ALL columns in ANY table that is displaying the
> "binary" word. I had this happen on my local box once but I can't remember
> how I fixed it.
> "Narayana Vyas Kondreddi" wrote:
>
>