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.
sql
No comments:
Post a Comment