Re: How to create XSD FROM DB

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Make sure that you indeed connect to SQL Server 2005....

The XML data type and XMLSCHEMA option work if you connect to SQL Server
2005, but obviously don't if you still connect to the 2000 instance.

And you can run 2000 and 2005 on the same machine, but you should use
different instance names...

best regards
Michael


"maurox" <mrago@xxxxxxxxx> wrote in message
news:1139053577.915104.237070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Ok, i've see the article, but i have a problem. i have installed new
sql server 2005 on my pc, but i dont have a XML data type and the
XMLSCHEMA option dont works. I have also the sql sever 2000 on the same
machine. now i want to know if i have a bad installation or the 2000
and 2005 can't stay on the same machine?
Thank you a lot! and sorry for my bad english!



.

Relevant Pages

  • Passing XML data type to a SQL Server 2005 procedure (BizTalk 2006)
    ... I'm using a stored procedure in SQL Server 2005 that can receive a XML ... parameter (with the new XML data type available with SQL Server 2005). ... The SQL adapter wizard generates a schema to make the request to the ... I would like to map a entire schema into that attribute but couldn't ...
    (microsoft.public.biztalk.general)
  • Re: Aggregate on XML Data Type
    ... Columnist, SQL Server Professional ... Toronto, ON Canada ... Is there a way to aggreate data on the XML data type? ...
    (microsoft.public.sqlserver.xml)
  • Re: reading xml from database..
    ... #XML Data Type Support in ADO.NET 2.0: Handling XML from SQL Server 2005 ... #XML Data type in ADO.Net v2.0 - Part II ... Microsoft MSDN Online Support Lead ... where an initial response from the community or a Microsoft Support ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Parsing large XML files?
    ... I get the following message when I try to execute the first query. ... create table dbo.xmlDocs(pkid smallint identity(-32767,1) primary ... I thought you were using SQL Server 2005 where we have the XML data type. ...
    (microsoft.public.sqlserver.xml)
  • Re: XML support in 2005?
    ... for functionality to be the primary concern during betas, ... Wayne Snyder, MCDBA, SQL Server MVP ... community of SQL Server professionals. ... > I've tested SQL 2005 Beta 2's XML data type support and I've concluded ...
    (microsoft.public.sqlserver.server)