Friday, March 23, 2012

I cant get the xml data type

I have just installed SQL server 2005 - Developer edition and the problem i get is: i dont have xml datatype available to me. I was able to use the xml datatye as long as i was using SQL server Express edition on a different machine. Please note that i have also applies SQL server 2005 SP-1 aswell but found no change in the datatypes available. I need urgent help in this regard.

During the installation i didnot install the reporting services as i did not need them.Has it something to do with it?XML datatype is avaiable for all SQL Server 2005 variation and service packs. Can you be more specific about "i dont have xml datatype available to me" ?|||

Well I meant that when i create a new table through design or query and type xml it generates and error message that xml datatyope is not defined. And here are the configuration of my machine:

OS: Windows XP - SP2

Hardware check: Intel Pentium 3 GHz processor 1 GB DDR RAM

I installed SQL server 2000 first and then SQL server 2005 dev. edition.

|||

Are you sure that you run the script against your SQL Server 2005 instance and not the SQL Server 2000 instance? What do you get if you say

select @.@.version

?

Thanks

Michael

No comments:

Post a Comment