The ' ' character, hexadecimal value 0x20, cannot be included in a name.

An XmlElement is something that look a bit like "" in
XML. If it has a space, then it won't be an element any more, because
that would make it look like "", and the 'thing' would look
like the start of an attribute.

So, either you need to rule out spaces, or you need to devise some
escaping mechanism to substitute the spaces with some other characters.

Select Only Year of Datetime MSSQL

SELECT DISTINCT CONVERT(CHAR(4), @DatetimeValue, 120) as Year

FROM Events

Select Only Month of Datetime MSSQL

SELECT DISTINCT CONVERT(CHAR(3),@DatetimeValue, 100) as MONTH

FROM Events

this server version is not supported. you must have microsoft sql server 2005 beta 2 or later

Microsoft Visual Studio 2005 Service Pack 1 Update for Microsoft SQL Server 2008 Support

Brief Description

This update enables developers to use Microsoft Visual Studio 2005 Service Pack 1 with Microsoft SQL Server 2008.

Download & Install it:

http://www.microsoft.com/downloads/details.aspx?FamilyID=E1109AEF-1AA2-408D-AA0F-9DF094F993BF&displaylang=en