Monday, March 26, 2012

Easy Newb Q? Cannot find data type xml?

I'm simply trying to create a column of datatype xml but I can't. I'm 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