|
dev
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Enterprise Manager displays nvarchar as <binary>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? 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-1DE62F076***@microsoft.com, "Dorota Laudon" <DorotaLau***@discussions.microsoft.com> wrote: Show quoteHide 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? > Management Studio is working fine. The problem is only related to Enterprise
Manager. Show quoteHide quote "Aaron Bertrand [SQL Server MVP]" wrote: > 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-1DE62F076***@microsoft.com, "Dorota Laudon" > <DorotaLau***@discussions.microsoft.com> wrote: > > > 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? > > > > > Management Studio is working fine. The problem is only related to Enterprise So why do you still need to use Enterprise Manager? They're not going to> Manager. fix it... I guess I could use Management Studio which I am going to install any way. I
would prefer to use EM because it is faster and it is enough for what I am doing now. I do not think that this is a EM bug. Something has changed in my system that affected the way that EM (MMC) in reading unicode chars. I just hoped that somebody had the same problem and vould point me in right direction to solve it. Show quoteHide quote "Aaron Bertrand [SQL Server MVP]" wrote: > > 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... > > Dorota Laudon (DorotaLau***@discussions.microsoft.com) writes:
> I had no problems with Enterprise Manager until recently. What do you mean with binary? You do really see 0x1234ABCD? Or something > At this moment the content of NVARCHAR columns is displayes as <binary>. else? -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.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/prodinfo/previousversions/books.mspx I see word <binary> instead of actual content which is supposed to be a any
text stored in the column (nvarchar) Show quoteHide quote "Erland Sommarskog" wrote: > Dorota Laudon (DorotaLau***@discussions.microsoft.com) writes: > > I had no problems with Enterprise Manager until recently. > > At this moment the content of NVARCHAR columns is displayes as <binary>. > > What do you mean with binary? You do really see 0x1234ABCD? Or something > else? > > > -- > Erland Sommarskog, SQL Server MVP, esq***@sommarskog.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/prodinfo/previousversions/books.mspx > > Dorota Laudon (DorotaLau***@discussions.microsoft.com) writes:
> I had no problems with Enterprise Manager until recently. Double-check that the data type is nvarchar. Maybe the type is varbinary> 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. 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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx 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 Show quoteHide quote "Erland Sommarskog" wrote: > Dorota Laudon (DorotaLau***@discussions.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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx > > Dorota Laudon (DorotaLau***@discussions.microsoft.com) writes:
> The data type is for sure nvarchar. I even changed it to char and then I That is unlikely. Did you run:> 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? >> as I suggested?>> exec sp_MShelpcolumns N'dbo.tablename, NULL >> -- Erland Sommarskog, SQL Server MVP, esq***@sommarskog.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/prodinfo/previousversions/books.mspx 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 Show quoteHide quote "Erland Sommarskog" wrote: > Dorota Laudon (DorotaLau***@discussions.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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx > > 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-9D017B1FE***@microsoft.com, "Dorota Laudon" <DorotaLau***@discussions.microsoft.com> wrote: Show quoteHide 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 (DorotaLau***@discussions.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, esq***@sommarskog.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/prodinfo/previousversions/books.mspx >> >>  
Other interesting topics
How to manage the transaction log
VS 2005 (BIDS) deploys the wrong data source connection string SSMS 2008 Add-ons: What is the 2008 replacement for SQLWB.EXE? Appending Data via BCP No management Studio SQL Server 2005 Error 2008 SSMS object explorer BCP Error 08001, Nativeerror 2 Maintenance Plan Fails script to cliboard in microsoft SQL server management studio |
|||||||||||||||||||||||
