By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,842 Members | 2,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,842 IT Pros & Developers. It's quick & easy.

Cannot find data type xml

P: n/a

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
Share this Question
Share on Google+
2 Replies


P: n/a
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

P: n/a

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.