Re: Enterprise Manager displays nvarchar as <binary>
- From: "Aaron Bertrand [SQL Server MVP]" <ten.xoc@xxxxxxxxxxxxxx>
- Date: Tue, 09 Jun 2009 19:55:22 -0400
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@xxxxxxxxxxxxx, "Dorota Laudon"
<DorotaLaudon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
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@xxxxxxxxxxxxxxxxxxxxxxxxx) 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@xxxxxxxxxxxxx
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/prodinfo/previousversions/books.mspx
.
- References:
- Enterprise Manager displays nvarchar as <binary>
- From: Dorota Laudon
- Re: Enterprise Manager displays nvarchar as <binary>
- From: Erland Sommarskog
- Re: Enterprise Manager displays nvarchar as <binary>
- From: Dorota Laudon
- Re: Enterprise Manager displays nvarchar as <binary>
- From: Erland Sommarskog
- Re: Enterprise Manager displays nvarchar as <binary>
- From: Dorota Laudon
- Enterprise Manager displays nvarchar as <binary>
- Prev by Date: Re: Backup database
- Next by Date: "loading of the imagelist did not succeed." error in SSMS 2005
- Previous by thread: Re: Enterprise Manager displays nvarchar as <binary>
- Next by thread: RE: Database diagrams in ss2008
- Index(es):
Relevant Pages
|
