in Microsoft SQL Server Management Studio 2005. I have all other
datatypes except XML... I thought it was supposed to be "built in".
CREATE TABLE T1(Col1 int primary key, Col2 xml)
gives me
Column or parameter #2: Cannot find data type xml.
I copied that straight out of the help. I must be missing something
really simple here such as an "Enable XML" in a properties window
somewhere? Thanks! You are in SQL Management Studio 2005 but are you sure you are connected to a SQL Server 2005 instance ? Perhaps you have a SQL 2000 Server instance on your machine and connected to it ?|||
I have the same problem.
This machine has never had any other version of SQL other than SQL 2005.
Created database in Management Studio.
|||Greetings,
I have encountered the same problem "Cannot find data type xml.".
I see that you have encountered the same problem but I have not been able to find the answer.
In my case I have a newly loaded Windows 2000 Server with all of the service packs and the trail version of SQL 2005 Exterprise.
When I try to create the table from the example in the book, which is the same create table example as above I get the message "Cannot find data type xml"
If I go into object explorer, tables, new tables and try and create the table from their xml is not listed as one of the data types.
Thanks for your help.
No comments:
Post a Comment