detaching a db in sql 6

greeting ya all,
I was just wondering of how to detach a database in sqlserver 6? is
it the transerfer tool'
MTIA,
GrawshaNow, this was a whole ago, but...
That would be the DROP DATABASE command. SQL Server didn't actually removed the disk devices in the
old architecture when you did DROP DATABASE (you created those devices explicitly and a device can
be shared among several databases).
The hard part is to do "attach", which involves DISK REINIT and DISK REFIT, something you really
only use for emergency recovery.
I suggest you save yourself *a lot* of trouble and do DUMP and LOAD (backup/(restore). And even that
is a lot harder in the old architecture, so make sure you read up on the subject if needed.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<grawsha2000@.yahoo.com> wrote in message
news:1170433784.946975.181760@.v45g2000cwv.googlegroups.com...
> greeting ya all,
> I was just wondering of how to detach a database in sqlserver 6? is
> it the transerfer tool'
> MTIA,
> Grawsha
>|||Add on to Tibor, In SQL 6.0 the best option to copy a database to one server
to another server will DUMP the database
and use LOAD Database in the destination server to Restore the database.
In SQL 6.0 there is no concept of files, all were devices and database will
reside above the devices.
Thanks
Hari
"grawsha2000@.yahoo.com" wrote:
> greeting ya all,
> I was just wondering of how to detach a database in sqlserver 6? is
> it the transerfer tool'
> MTIA,
> Grawsha
>

Designing Database Diagramm

Hi,
i am looking for a tool to design den model of a database.
i took a look at powerdesigner, embacadero..
which one do you prefer to design the model.
i am using SQL SERVER 2005.
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Forum...amming/200602/1HI,
There are quite a few out there,
Erwin,
Visio,
Case Studio
Datanamics Dezign
All depends on the indivisual, the project, what you like, what you want to
do.
I use both case studio and dezign, because it fits my needs and I can afford
it.
Robert
"fantasimus via webservertalk.com" <u16093@.uwe> wrote in message
news:5bf54d8709c30@.uwe...
> Hi,
> i am looking for a tool to design den model of a database.
> i took a look at powerdesigner, embacadero..
> which one do you prefer to design the model.
> i am using SQL SERVER 2005.
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Forum...amming/200602/1

designer wanted

Hi!
I'm looking for (preferably free) a tool that is useful in graphical
representation of DB (something like Oracle Designer). Could you give me
some hints where to find one?
Thanx
Yaro
Visio is pretty good for any type of UML design as well as E-R Diagramming.
It can even generate classes for you as well as the SQL needed to create the
objects.
Its' relatively inexpensive as far as designers go.
Rick Sawtell
"Jarosaw Tajcher" <ziomuch@.wp.pl> wrote in message
news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> Hi!
> I'm looking for (preferably free) a tool that is useful in graphical
> representation of DB (something like Oracle Designer). Could you give me
> some hints where to find one?
> Thanx
> Yaro
>
|||The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Acc
ess).
Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
Tea C.
"Rick Sawtell" wrote:

> Visio is pretty good for any type of UML design as well as E-R Diagramming.
> It can even generate classes for you as well as the SQL needed to create the
> objects.
> Its' relatively inexpensive as far as designers go.
>
> Rick Sawtell
>
> "Jaros3aw Tajcher" <ziomuch@.wp.pl> wrote in message
> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
>
>
|||There is no inexpensive tool for data modelling. While the SQL Server,
Access and Visio, may work they all have drawbacks.
One key feature is the ability to create a database or at least tables
in a database directly from a diagram and to have changes in the
diagram relect in the tables and relationships.
Anothe key feature of a tool is the ability to store elements of the
model ina repository for future re-use. Any experience developer would
love to carry around a file of tables used on other projects as a
short cut to designing the current project.
Lastly, you should look for the data and OODB (UML) modeling symbols
for Visio that may now exist, some for no fee, if your goal is OODBs.
Lou Arnold
On Sat, 24 Jul 2004 19:06:02 -0700, "=?Utf-8?B?VGVhQw==?="
<smece1972@.yahoo.com.nospam> wrote:

>The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Ac
cess).[vbcol=seagreen]
>Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
>--
>Tea C.
>
>"Rick Sawtell" wrote:

designer wanted

Hi!
I'm looking for (preferably free) a tool that is useful in graphical
representation of DB (something like Oracle Designer). Could you give me
some hints where to find one?
Thanx
YaroVisio is pretty good for any type of UML design as well as E-R Diagramming.
It can even generate classes for you as well as the SQL needed to create the
objects.
Its' relatively inexpensive as far as designers go.
Rick Sawtell
"Jarosaw Tajcher" <ziomuch@.wp.pl> wrote in message
news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> Hi!
> I'm looking for (preferably free) a tool that is useful in graphical
> representation of DB (something like Oracle Designer). Could you give me
> some hints where to find one?
> Thanx
> Yaro
>|||The SQL Server (assuming you have already paid for it) comes with a diagramm
ing tool. Also, MS Access (in case you aready have a copy of it) has a "rel
ationship" tool which might be useful for your project (you can import prett
y much any data into MS Acc
ess).
Not exactly, what you asked for, but you might already have the tool you are
looking for...in your hands...
Tea C.
"Rick Sawtell" wrote:

> visio is pretty good for any type of UML design as well as E-R Diagramming
.
> It can even generate classes for you as well as the SQL needed to create t
he
> objects.
> Its' relatively inexpensive as far as designers go.
>
> Rick Sawtell
>
> "Jaros3aw Tajcher" <ziomuch@.wp.pl> wrote in message
> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
>
>|||There is no inexpensive tool for data modelling. While the SQL Server,
Access and Visio, may work they all have drawbacks.
One key feature is the ability to create a database or at least tables
in a database directly from a diagram and to have changes in the
diagram relect in the tables and relationships.
Anothe key feature of a tool is the ability to store elements of the
model ina repository for future re-use. Any experience developer would
love to carry around a file of tables used on other projects as a
short cut to designing the current project.
Lastly, you should look for the data and OODB (UML) modeling symbols
for visio that may now exist, some for no fee, if your goal is OODBs.
Lou Arnold
On Sat, 24 Jul 2004 19:06:02 -0700, "examnotes"
<smece1972@.yahoo.com.nospam> wrote:

>The SQL Server (assuming you have already paid for it) comes with a diagramming too
l. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool
which might be useful for your project (you can import pretty much any data into MS
Ac
cess).[vbcol=seagreen]
>Not exactly, what you asked for, but you might already have the tool you ar
e looking for...in your hands...
>--
>Tea C.
>
>"Rick Sawtell" wrote:
>

designer wanted

Hi!
I'm looking for (preferably free) a tool that is useful in graphical
representation of DB (something like Oracle Designer). Could you give me
some hints where to find one?
Thanx
YaroVisio is pretty good for any type of UML design as well as E-R Diagramming.
It can even generate classes for you as well as the SQL needed to create the
objects.
Its' relatively inexpensive as far as designers go.
Rick Sawtell
"Jaros³aw Tajcher" <ziomuch@.wp.pl> wrote in message
news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> Hi!
> I'm looking for (preferably free) a tool that is useful in graphical
> representation of DB (something like Oracle Designer). Could you give me
> some hints where to find one?
> Thanx
> Yaro
>|||The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Access).
Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
--
Tea C.
"Rick Sawtell" wrote:
> Visio is pretty good for any type of UML design as well as E-R Diagramming.
> It can even generate classes for you as well as the SQL needed to create the
> objects.
> Its' relatively inexpensive as far as designers go.
>
> Rick Sawtell
>
> "Jaros³aw Tajcher" <ziomuch@.wp.pl> wrote in message
> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
> > Hi!
> > I'm looking for (preferably free) a tool that is useful in graphical
> > representation of DB (something like Oracle Designer). Could you give me
> > some hints where to find one?
> > Thanx
> > Yaro
> >
> >
>
>|||There is no inexpensive tool for data modelling. While the SQL Server,
Access and Visio, may work they all have drawbacks.
One key feature is the ability to create a database or at least tables
in a database directly from a diagram and to have changes in the
diagram relect in the tables and relationships.
Anothe key feature of a tool is the ability to store elements of the
model ina repository for future re-use. Any experience developer would
love to carry around a file of tables used on other projects as a
short cut to designing the current project.
Lastly, you should look for the data and OODB (UML) modeling symbols
for Visio that may now exist, some for no fee, if your goal is OODBs.
Lou Arnold
On Sat, 24 Jul 2004 19:06:02 -0700, "=?Utf-8?B?VGVhQw==?="
<smece1972@.yahoo.com.nospam> wrote:
>The SQL Server (assuming you have already paid for it) comes with a diagramming tool. Also, MS Access (in case you aready have a copy of it) has a "relationship" tool which might be useful for your project (you can import pretty much any data into MS Access).
>Not exactly, what you asked for, but you might already have the tool you are looking for...in your hands...
>--
>Tea C.
>
>"Rick Sawtell" wrote:
>> Visio is pretty good for any type of UML design as well as E-R Diagramming.
>> It can even generate classes for you as well as the SQL needed to create the
>> objects.
>> Its' relatively inexpensive as far as designers go.
>>
>> Rick Sawtell
>>
>> "Jaros³aw Tajcher" <ziomuch@.wp.pl> wrote in message
>> news:cdrpao$q7e$1@.nemesis.news.tpi.pl...
>> > Hi!
>> > I'm looking for (preferably free) a tool that is useful in graphical
>> > representation of DB (something like Oracle Designer). Could you give me
>> > some hints where to find one?
>> > Thanx
>> > Yaro
>> >
>> >
>>

Design Tool and Security roles

I have 2005 SP1 and after adding the new users to the Server in Studio, I go to the Design tool and create a new role, I add the user and check the following: process database and read definition.

I then go to Cell Data Tab and select Test Cube Secuirty; when asked if I want to deploy the cube I say "yes". after I deploy it I get the following message: "You are browing the cube using credential of the following roles: Sales" then I get the message below that

"Connection can not be made. Ensure the server is running" and

No connection could be made because the target server actively refused it.

I am connected to the cube so its running, remote connection are allowed, I already connected, just attempting to define and test other roles? Is there an issue with Test cube security? any suggestions?

Try to re-connect your Cube browser after deploying the solution.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Yes, I do reconnect to my cube but I always get the error message, I can't test security, even though the roles I defined do allow the users to access the cube I still get this message. Thank you,|||

It is a bit strang situation.

What worries me is that you say "adding the new users to the Server in Studio, I go to the Design tool and create a new role".

You should'nt go and manage your security in different places. If you to add uses in SQL Management Studio, next time you deploy your solution, Role memebership will get overwritten. Try to make all the changes in BI Dev Studio.

I would also recommend you upgrde your Analysis Services to SP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

Maybe I miscommunicated that, I do make them in the design tool, I keep all my roles in the BI tool but I started to try to test them there before I deploy them and I can't test them that was my error. When I go to CELL Data and select "test Cube Security" I get the error.

Thank you,

Janet

|||

One litte trick to troubleshoot your problem.

Try deploying the solution from BI Dev Studio. Process it. Then go back to SQL Management Studio and try to browse your cube under different user or role to test your securtiy.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward,

I don't know how to browse the cube under a different role in SQL Managment Studio.

I think we have moved onto a different direction, let me try to explain a little better.

All my roles actually work when the user accesses the cube the defect or error is I can't "test the role" in BI Development tool. If I select a role that I know actully works and attempt to do the test from I go to the "Cell Data" tab and click on Test Cube Security using a role that I know allows the user access I get this message " your are browing a cube using the following role: process and read" - connection can not be made insure the server is running. But if i check with the users in that role, all the users in that role can access the cube.

So my problem is not that the role is not allowing access, its that Test Cube Security gives me a bogus error, because that role can access and browse the cube.

Thank you,

Janet

|||

Just wondering does the "test cube security" actually work in the BI tool for everyone but me? is anyone else having this problem?

thank you

Design Tool and Security roles

I have 2005 SP1 and after adding the new users to the Server in Studio, I go to the Design tool and create a new role, I add the user and check the following: process database and read definition.

I then go to Cell Data Tab and select Test Cube Secuirty; when asked if I want to deploy the cube I say "yes". after I deploy it I get the following message: "You are browing the cube using credential of the following roles: Sales" then I get the message below that

"Connection can not be made. Ensure the server is running" and

No connection could be made because the target server actively refused it.

I am connected to the cube so its running, remote connection are allowed, I already connected, just attempting to define and test other roles? Is there an issue with Test cube security? any suggestions?

Try to re-connect your Cube browser after deploying the solution.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||Yes, I do reconnect to my cube but I always get the error message, I can't test security, even though the roles I defined do allow the users to access the cube I still get this message. Thank you,|||

It is a bit strang situation.

What worries me is that you say "adding the new users to the Server in Studio, I go to the Design tool and create a new role".

You should'nt go and manage your security in different places. If you to add uses in SQL Management Studio, next time you deploy your solution, Role memebership will get overwritten. Try to make all the changes in BI Dev Studio.

I would also recommend you upgrde your Analysis Services to SP2.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Edward,

Maybe I miscommunicated that, I do make them in the design tool, I keep all my roles in the BI tool but I started to try to test them there before I deploy them and I can't test them that was my error. When I go to CELL Data and select "test Cube Security" I get the error.

Thank you,

Janet

|||

One litte trick to troubleshoot your problem.

Try deploying the solution from BI Dev Studio. Process it. Then go back to SQL Management Studio and try to browse your cube under different user or role to test your securtiy.

HTH

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Hi Edward,

I don't know how to browse the cube under a different role in SQL Managment Studio.

I think we have moved onto a different direction, let me try to explain a little better.

All my roles actually work when the user accesses the cube the defect or error is I can't "test the role" in BI Development tool. If I select a role that I know actully works and attempt to do the test from I go to the "Cell Data" tab and click on Test Cube Security using a role that I know allows the user access I get this message " your are browing a cube using the following role: process and read" - connection can not be made insure the server is running. But if i check with the users in that role, all the users in that role can access the cube.

So my problem is not that the role is not allowing access, its that Test Cube Security gives me a bogus error, because that role can access and browse the cube.

Thank you,

Janet

|||

Just wondering does the "test cube security" actually work in the BI tool for everyone but me? is anyone else having this problem?

thank you

Design Question

Dear All,
I have the following design issue which I am unsure how to solve.
Here's the key information:
I am writing a tool which will send emails/SMS to registered users. The
registered user data will be stored in one database (we'll call it
DB1). No changes can be made to DB1. All information related to the
tool will be stored in a different database (we'll call it DB2). This
will include the following tables (among others):
- "Sent Email" table to store which user (from DB1) received what email
- "User" table to store individuals who have permission to login to the
tool
- "Email Template" table to store email templates
- "Email Template Log" table to record which user created/edited the
template
My specific problem is how to model these relationships in DB2. Will
DB2 contain a "User Look Up" table which stores the ID (PK) of the user
from DB1? Therefore my "Sent Email" table will have a FK from this look
up table? In addition if the scenario was that I needed to record an
attribute "Don't send me messages" would this be stored on the look up
table as well?
Thanks for any help in advance.
Jose"Jose" <discussions@.avandis.co.uk> wrote in message
news:1135436233.215881.325210@.g14g2000cwa.googlegroups.com...
> Dear All,
> I have the following design issue which I am unsure how to solve.
> Here's the key information:
> I am writing a tool which will send emails/SMS to registered users. The
> registered user data will be stored in one database (we'll call it
> DB1). No changes can be made to DB1. All information related to the
> tool will be stored in a different database (we'll call it DB2). This
> will include the following tables (among others):
> - "Sent Email" table to store which user (from DB1) received what email
> - "User" table to store individuals who have permission to login to the
> tool
> - "Email Template" table to store email templates
> - "Email Template Log" table to record which user created/edited the
> template
> My specific problem is how to model these relationships in DB2. Will
> DB2 contain a "User Look Up" table which stores the ID (PK) of the user
> from DB1? Therefore my "Sent Email" table will have a FK from this look
> up table? In addition if the scenario was that I needed to record an
> attribute "Don't send me messages" would this be stored on the look up
> table as well?
> Thanks for any help in advance.
> Jose
>
I guess you'll need a Users table in DB2. What you won't be able to do is
create a foreign key on it that references DB1. Cross-database constraints
aren't supported. You could create a view in DB2 that references the Users
table in DB1.
Have you considered using Notification Services? All you've described and
more ...
http://www.microsoft.com/sql/techno...on/default.mspx
Both 2000 and 2005 editions of NS are available.
David Portas
SQL Server MVP
--

Design Pane.

I cannot find the Query Design GUI Tool.
Where is it located?
R
Personally, I use Query Analyzer and write all of my select statements. =
I find this easier, faster, more powerful, and more flexible than a =
poorly designed multi pane query design "tool." I have total control =
over the sql that is generated within Query Analyzer and I have the =
ability to highlight a keyword and hit Ctrl-F1 to access Books Online.
With that said, one way that I know of to access the query designer is =
to navigate to a table via Enterprise Manager, Right click | Open Table =
| Query. The designer appears.
--=20
Keith
"Richard" <anonymous@.discussions.microsoft.com> wrote in message =
news:ec2001c43cfc$ceffc3f0$a501280a@.phx.gbl...
> I cannot find the Query Design GUI Tool.
>=20
> Where is it located?
>=20
> R

Deserialize xml data from sql 2005

We're having a hard time with SQL 05's xml.
In a nutshell, I have a schema. I have used .Net 2.0's xsd tool to create classes from this schema.

This schema is also tied to a XML column in my database server. So far so good.

However, when I go to deserialize the xml data stored in the database server I'm getting inconsistent results. Namely the differences in the following queries:
SELECT LoanXML.query('declare namespace MISMO="http://mrgdev.local/mismo/";//MISMO:LOAN')
FROM Loans
WHERE Loans.InternalID = @.LoanID

returns something completely different from:
SELECT LoanXML from Loans where InternalID = @.LoanID

The difference is that the first query throws xsi:nil=true into EVERY SINGLE NODE. Whereas the second one doesn't.

When we go to deserialize, then the nodes aren't converting into objects even though they are properly filled out...

I'd just chuck the .query syntax, except for a little problem where I'm trying to return just the node(s) I want instead of the whole thing.

Is there anyone else using xml deserialization with SQL 05?<xs:schema

xmlns:xs="http://www.w3.org/2001/XMLSchema"

xmlns="http://mrgdev.local/mismo/"

targetNamespace="http://mrgdev.local/mismo/"

elementFormDefault="qualified">
<xs:import namespace="http://www.w3.org/XML/1998/namespace" schemaLocation=".\xml.xsd"/>
<xs:element name="LOAN" nillable="false">
<xs:complexType>
<xs:sequence>
<xs:element name="_APPLICATION" nillable="true" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="_DATA_INFORMATION" nillable="true" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element ref="DATA_VERSION"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>

<xs:element name="DATA_VERSION" nillable="true">
<xs:complexType>
<xs:attribute name="_Name" type="xs:string" use="required"/>
<xs:attribute name="_Number" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>|||CREATE XML SCHEMA COLLECTION [dbo].[ChrisSchema]
AS N'<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns="http://mrgdev.local/test/"
xmlns:dv="http://mrgdev.local/DV/"
targetNamespace="http://mrgdev.local/test/" elementFormDefault="qualified">
<xs:import namespace="http://www.w3.org/XML/1998/namespace" schemaLocation=".\xml.xsd"/>
<xs:element name="LOAN" nillable="false">
<xs:complexType>
<xs:sequence>
<xs:element name="_APPLICATION" nillable="true" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element name="_DATA_INFORMATION" nillable="true" minOccurs="0">
<xs:complexType>
<xs:sequence>
<xs:element ref="DATA_VERSION"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="DATA_VERSION" nillable="true">
<xs:complexType>
<xs:attribute name="_Name" type="xs:string" use="required"/>
<xs:attribute name="_Number" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>
'|||The following creates a table and inserts a row with xml data into it.

CREATE TABLE [dbo].[MyTest](
[id] [uniqueidentifier] NOT NULL CONSTRAINT [DF_mytest_id] DEFAULT (newid()),
[test] [xml](CONTENT [dbo].[ChrisSchema]) NULL,
CONSTRAINT [PK_chris] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

insert into MyTest(test)
values('<LOAN xmlns="http://mrgdev.local/test/"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://mrgdev.local/test/">
<_APPLICATION>
<_DATA_INFORMATION>
<DATA_VERSION _Name="DVTESt" _Number="123123"/>
</_DATA_INFORMATION>
</_APPLICATION>
</LOAN>')|||Now, execute

SELECT test.query('declare namespace test="http://mrgdev.local/test/";//test:LOAN')
FROM MyTest

You're result will be:

<LOAN xmlns="http://mrgdev.local/test/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://mrgdev.local/test/">
<_APPLICATION>
<_DATA_INFORMATION>
<DATA_VERSION _Name="DVTESt" _Number="123123" xsi:nil="true" />
</_DATA_INFORMATION>
</_APPLICATION>
</LOAN>

Notice the xsi:nil=true... First off, that's wrong. It isn't nil. Second, this will not deserialize. WTF?|||If I just run

select test from MyTest

then the data looks like:

<LOAN xmlns="http://mrgdev.local/test/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://mrgdev.local/test/">
<_APPLICATION>
<_DATA_INFORMATION>
<DATA_VERSION _Name="DVTESt" _Number="123123" />
</_DATA_INFORMATION>
</_APPLICATION>
</LOAN>

In this case the data_version node correctly comes back WITHOUT the xsi:nil="true"
In addition, if we UNTYPE the xml column, then it will also come back without the xsi:nil="true"garbage; but that's not a real option.

How do we get the typed version to not do this? I even tried placing the definition for DATA_VERSION in a different schema, but this had zero effect on our output.|||After all of our testing, it appears that if an element only has attributes then it reports the element as xsi:nil="true" which in our case is wrong, because our elements only have attributes.

Is there some way to get around this?