Skip to main content
Share Your Experience: Take the 2024 Developer Survey

Questions tagged [xsd]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0 votes
1 answer
914 views

Loading Extended Events ring buffer to SQL table using powershell

I am running a RPC_Completed extended event which outputs to a ring buffer. While trying to read the data from the ring buffer target data, xQuery is taking too much of time. The faster route was to ...
Mobious's user avatar
  • 11
0 votes
2 answers
811 views

ORA-22285 Error while trying to register an xsd schema on oracle database

Here is the code for user "system" create or replace directory xml_mape as 'D:\app\Gusts\xml_mape'; GRANT READ,WRITE ON DIRECTORY xml_mape to lietotajs; Im trying to access the xsd file "dok1_shema....
John's user avatar
  • 11
3 votes
1 answer
5k views

Generate DDL Statement from XSD file

I have a database schema exported into XML format. My goal is to create a DDL statement from the XSD files that I can use to import the data into a different platform without manually having to ...
Seb's user avatar
  • 51
3 votes
1 answer
2k views

How to script XML Schema collection in SQL Server 2012?

I need to make script of XML schema collections in my Database and then insert each xml inside a table field as string. I need to do this to compare current schema collections with the new schema ...
Bogdan Bogdanov's user avatar
5 votes
1 answer
6k views

How to resolve this 'XML Validation: Declaration not found for element' error?

I'm new to SQL Server and I have this task to complete (for learning purposes), yet I'm unable to figure out this error due to inexperience with XML Schemas (I think) Here's what I'm trying to do - ...
PalashV's user avatar
  • 213
2 votes
2 answers
3k views

Is there a way to validate XML using variable as schema?

Is there a way to declare XSD schema as variable inside a construct: DECLARE @xml XML(Books)? I need to make quick validation of XML using XSD schema which is declared as variable. I suppose there is ...
Bogdan Bogdanov's user avatar
4 votes
1 answer
4k views

SQL 2012 CLR error: "The context transaction which was active before entering ..."?

I am experience strange error with SQL 2012 and CLR: The context transaction which was active before entering user defined routine, trigger or aggregate "My routine" has been ended inside of it,...
Bogdan Bogdanov's user avatar
2 votes
1 answer
63 views

What's the relationship between Documents, XSDs and Collections?

I have a number of XML Schema Definitions describing business objects. It's unclear to me what the correct way to deploy these is if my intention is to make typed xml columns. The name Xml Schema ...
Jeff Sacksteder's user avatar