Also, a lot of new users sometimes confuse the tools with the server.
Next time you're connected, Steve, run these commands which will tell
you which version you're really working with, along with the
compatibility level that Bob talks about:
SELECT @@VERSION;
SELECT name, compatibility_level FROM sys.databases
WHERE name = '<MYDBNAME>'
[quoted text, click to view] Bob Simms wrote:
> "leobowee" <joshua_liubo@126.com> wrote in message
> news:ulgMy4hWHHA.5008@TK2MSFTNGP05.phx.gbl...
>> I made the querry like this below:
>>
>> DECLARE @doc xml
>> SELECT @doc = '£¼Team name="Braves" /£¾'
>>
>> but the SQL2005 told me that he can not find the XML datetype!
>>
>> I am appriciate if someone so kind to help me!Thanks!
> Go to the properties of your database and check the compatability level. It
> should be 90(sql 2005). If it was converted from a previous version of SQL
> Server it may well have the compatability level set too low for xml
> datatypes.
>
[quoted text, click to view] "leobowee" <joshua_liubo@126.com> wrote in message
news:ulgMy4hWHHA.5008@TK2MSFTNGP05.phx.gbl...
>I made the querry like this below:
>
> DECLARE @doc xml
> SELECT @doc = '£¼Team name="Braves" /£¾'
>
> but the SQL2005 told me that he can not find the XML datetype!
>
> I am appriciate if someone so kind to help me!Thanks!
Go to the properties of your database and check the compatability level. It
should be 90(sql 2005). If it was converted from a previous version of SQL
Server it may well have the compatability level set too low for xml
datatypes.
Thank you,David Markle.
I have execed that command,the real version of my sql connection is sql8.0.
Then I instilled sql9.0 Database Server Engine,and now I can use the newest
technology!
