468,316 Members | 2,087 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,316 developers. It's quick & easy.

Cannot find data type xml


I am getting this error when running on my local instance of SQL
server, but it is not an issue when running on our development SQL
Server box.

Code:
--variable declarations
declare @XmlDocument xml --2GB limit
declare @docHandle int

Msg 2715, Level 16, State 3, Line 14
Column or parameter #-1: Cannot find data type xml.
Parameter '@XmlDocument' has an invalid data type.
Sep 8 '08 #1
2 5234
The XML data type was added in SQL Server 2005. You need to make sure
your local instance is SQL Server 2005/2008. If the database was
upgraded, then you can check the compatibility level (under Database
properties, Options) and make sure it is set to SQL Server 2005 (90) or
SQL Server 2008 (100).

--
Plamen Ratchev
http://www.SQLStudio.com
Sep 8 '08 #2

Thank you. I mistakenly connected to a SQL 2000 instance.

On Sep 8, 11:33*am, Plamen Ratchev <Pla...@SQLStudio.comwrote:
The XML data type was added in SQL Server 2005. You need to make sure
your local instance is SQL Server 2005/2008. If the database was
upgraded, then you can check the compatibility level (under Database
properties, Options) and make sure it is set to SQL Server 2005 (90) or
SQL Server 2008 (100).

--
Plamen Ratchevhttp://www.SQLStudio.com
Sep 8 '08 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Wayne Brantley | last post: by
3 posts views Thread by David T. Ashley | last post: by
4 posts views Thread by =?Utf-8?B?VG9yZW4gVmFsb25l?= | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.