Re: Enterprise Manager displays nvarchar as <binary>

#1

Did you try Management Studio from SQL Server 2005 or SQL Server 2008?

On 6/4/09 12:09 PM, in article
C7D2A1CA-9474-4254-A3D2-1DE62F076B51...soft (DOT) com, "Dorota Laudon"
<DorotaLaudon (AT) discussions (DOT) microsoft.com> wrote:

Quote:

Hi everyone

I had no problems with Enterprise Manager until recently.
At this moment the content of NVARCHAR columns is displayes as <binary>.

If the datatype is changed to varchar the contents is displayed correctly.
The data content is also shown correctly from SQL Query Analyzer but VIEW
and TABLE browsing in EM has the problem mentioned above.

I uninstalled SQL Server Client Tools and installed them back without any
success in solving the problem.

OS: XP sp 3 SQL Server Client : sp 3

Any ideas?

#2

Quote:

Management Studio is working fine. The problem is only related to Enterprise
Manager.

So why do you still need to use Enterprise Manager? They're not going to
fix it...

#3

The data type is for sure nvarchar. I even changed it to char and then I
could see the content. When I changed it back to nvarchar the word <binary>
appeared again.
Can it bee some kind of the virus in my system?
I was told that my cooworker has the same problem and it it started
probably the same day that on my computer.

Dorota Laudon

"Erland Sommarskog" wrote:

Quote:

Dorota Laudon (DorotaLaudon (AT) discussions (DOT) microsoft.com) writes:
I had no problems with Enterprise Manager until recently.
At this moment the content of NVARCHAR columns is displayes as <binary>.

If the datatype is changed to varchar the contents is displayed correctly.
The data content is also shown correctly from SQL Query Analyzer but VIEW
and TABLE browsing in EM has the problem mentioned above.

I uninstalled SQL Server Client Tools and installed them back without any
success in solving the problem.

Double-check that the data type is nvarchar. Maybe the type is varbinary
after all.

What does this query say:

exec sp_MShelpcolumns N'dbo.tablename, NULL

This is the query that EM runs to find out the definition of the table.

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#4

Dorota Laudon (DorotaLaudon (AT) discussions (DOT) microsoft.com) writes:

Quote:

The data type is for sure nvarchar. I even changed it to char and then I
could see the content. When I changed it back to nvarchar the word
binary> appeared again.
Can it bee some kind of the virus in my system?

That is unlikely. Did you run:

Quote:

exec sp_MShelpcolumns N'dbo.tablename, NULL

as I suggested?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#5

I ran your query from SQL Query Analyzer on one of the tables in the database
and it showed nvarchar type

I have nvarchar in all tables and we do not use binary column at all in our
databases so there is no way that the binary datatype was defined.

Dorota

"Erland Sommarskog" wrote:

Quote:

Dorota Laudon (DorotaLaudon (AT) discussions (DOT) microsoft.com) writes:

The data type is for sure nvarchar. I even changed it to char and then I
could see the content. When I changed it back to nvarchar the word
binary> appeared again.
Can it bee some kind of the virus in my system?

That is unlikely. Did you run:

exec sp_MShelpcolumns N'dbo.tablename, NULL

as I suggested?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

#6

Is Enterprise Manager running on the server or are you running remotely? Is
it possible that the workstation has the original client tools (from the CD)
with no service packs installed whatsoever? Also is the destination server
SQL Server 2005, and is the column NVARCHAR(MAX) or NVARCHAR(<=4000)? If
the former then what you are trying to do probably isn't supported. I asked
before, but I'll mention it again, why do you need Enterprise Manager to
work? Not that Open Table is ever a good idea anyway, but if you have
access to Management Studio, I don't understand why you don't just use that
tool.

On 6/9/09 2:55 PM, in article
410C6B0E-10DD-444E-B124-9D017B1FE424...soft (DOT) com, "Dorota Laudon"
<DorotaLaudon (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I ran your query from SQL Query Analyzer on one of the tables in the database
and it showed nvarchar type

I have nvarchar in all tables and we do not use binary column at all in our
databases so there is no way that the binary datatype was defined.

Dorota

"Erland Sommarskog" wrote:

Dorota Laudon (DorotaLaudon (AT) discussions (DOT) microsoft.com) writes:

The data type is for sure nvarchar. I even changed it to char and then I
could see the content. When I changed it back to nvarchar the word
binary> appeared again.
Can it bee some kind of the virus in my system?

That is unlikely. Did you run:

exec sp_MShelpcolumns N'dbo.tablename, NULL

as I suggested?

--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Enterprise Manager displays nvarchar as <binary>

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Re: Enterprise Manager displays nvarchar as <binary> - 06-04-2009 , 01:40 PM

Re: Enterprise Manager displays nvarchar as <binary> - 06-04-2009 , 03:23 PM

Re: Enterprise Manager displays nvarchar as <binary> - 06-08-2009 , 11:43 AM

Re: Enterprise Manager displays nvarchar as <binary> - 06-08-2009 , 05:19 PM

Re: Enterprise Manager displays nvarchar as <binary> - 06-09-2009 , 01:55 PM

Re: Enterprise Manager displays nvarchar as <binary> - 06-09-2009 , 06:55 PM