SQL Server XML

Hi to everybody ! I have this schema: create xml schema collection UserRightsSchemaCollectionV1 as ' <xsd:schema targetNamespace="urn:Repository:UserRights" xmlns ="urn:Repository:UserRights" elementFormDefault="qualified" attributeFormDefault="unqualified" xmlns:xsd="http://www.w3.org/2001/XMLSchema" > <xsd:element name="Rights" xmlns:IsDataSet="true"> ...

fghgfh ...

How can I import my word documents into SQL server 2000? ...

Hi to everybody ! Please tell me how I can create a XML schema namespace ? What command is for that ? Thank you, Mihai ...

Our .NET app is using SqlXML version 3.0.1523.0 to retrieve XML documents from our SQL 2005 SP2 database.  Profiling the system, I see that the SPID that is used to call our procs always issues a SET ...

I have a CLR function thet returns IEnumberable (a table) and it has a FillRow function. I am returning 10,000 integers from this function. Is there any way that I can preallocate the resulting table or give SQL server ...

Hi, I'm trying to create a user-defined XML datatype in MSSQL 2005 SP2. This is the schema: [link] When I try to create the datatype using the SQL below, I get an error ...

Hi. thanks for your help. I appreciate you time and effort in helping me. I am trying to create xsd schema and validate an xml as typed. I have been reading as much as I could in SQL BOL and seem to define it correctly. I can schema collection and it appears to be valid. ...