Determine rowguid in column and edit column information ASP.NET 1.1 C#

What query should I run?

1. To determine whether a column is a rowguid or not using C# .NET 1.1

2. To add/modify column information and be able to set/change:

- Primary key

- Column Name

- Data Type

- Length

- Allow Null

- Default value

- Precision

- Scale

- Identity

- Identity Seed

- Identity Increment

- Row guid

Thanks a lot!

(1) SELECT OBJECTPROPRTTY(<tableId>,TableHasRowGuidCol) will tell you if the table has uniqueidentifier column.

(2) Please refer BOL.

|||

Hi, thanks for the answer but I tried to run this:

SELECT

OBJECTPROPERTY(OBJECT_ID('temp_aspnet_Permissions'),TableHasRowGuidCol)

and it gives me error:

Msg 207, Level 16, State 1, Line 1

Invalid column name 'TableHasRowGuidCol'.

|||

Never mind, I forgot about the quote:

SELECT

OBJECTPROPERTY(OBJECT_ID('temp_aspnet_Permissions'),'TableHasRowGuidCol')

Thanks again!

|||Btw, it only returning number 1 or 0, I need to know which column that has rowguid, so it still hasn't answer my question :(|||

I found it, you need to use columnproperty. Thanks again for the guidance!

SELECTCOLUMNPROPERTY(OBJECT_ID('testcol2'),'col2','IsRowGuidCol')

|||

SELECT

COLUMNPROPERTY(id,name,'IsRowGuidCol'),*

FROMsyscolumnsWHEREid=Object_Id('yourtable')

andCOLUMNPROPERTY(id,name,'IsRowGuidCol') = 1

determine if autoincrement is set in a table, form asp.net

I want to access sqlserver table properties from asp.net .

How do i know that a table defined in sqlserver has autoincrement field or not.

Actually i have to access all the tables in a database and execute different function for table with auto increment on and off.

I am not being able identify this property from codes.
Please help.
thank you

Hey,

When you connect to the database, you can't know that from ADO.NET; you have to recreate identities manually on the ADO.NET side. However, if you have SQL Server 2005 API's installed, you can use the SMO objects to connect to a 7.0, 2000, or 2005 database and find this information out.

|||Thanks brian

I am using sql 2000 and SqlDataAdapter object

I think the following code should work but its not working.
any ideas

Dim dsAs DataSet ' = ( got dataset from a table)
Dim hasAutoIncrementAsBoolean =FalseForEach columnAs DataColumnIn ds.Tables(0).Columns If column.AutoIncrementThen

hasAutoIncrement =

True
ExitFor EndIfNext|||

Hey,

The problem is there isn't any autoincrement returned back from the dataset; you have to establish that programatically. So you need to do:

dataSet.Tables(0).Columns(0).AutoIncrement = true
dataSet.Tables(0).Columns(0).AutoIncrementStep = 1

Etc. You have to set this up by yourself; it doesn't pull it back for you.

|||

SELECT *,COLUMNPROPERTY(OBJECT_ID(TABLE_NAME),COLUMN_NAME,'IsIdentity')AS IS_IDENTITYFROM INFORMATION_SCHEMA.COLUMNS

|||

Which would lead you to this query:

SELECT COUNT(*)

FROM (

SELECT

*,COLUMNPROPERTY(OBJECT_ID(TABLE_NAME),COLUMN_NAME,'IsIdentity')AS IS_IDENTITY

FROM

INFORMATION_SCHEMA.COLUMNS

) t1

WHERETABLE_NAME=@.MyTable AND IS_IDENITITY=1

|||Thank you very muchMotley

exactly what i was looking for.

Thanks

detect and solve deadlocks

Is there any way by which deadlocks can be detacted and then appropriate
action can be taken (in vb.net code or sql) to avoid it. instead of throwing
error we can revoke the sp call..
thankshttp://www.sql-server-performance.com/deadlocks.asp
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>|||http://msdn.microsoft.com/library/d...
tabse_5xrn.asp
Troubleshooting Deadlocks
http://www.support.microsoft.com/?id=224453 Blocking Problems
http://www.support.microsoft.com/?id=271509 How to monitor SQL 2000
Blocking
Andrew J. Kelly SQL MVP
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>|||You can determine what processes are currently blocking other processes by
running sp_who and looking for SPIDs in the [blkby] column.
http://msdn2.microsoft.com/ms174313.aspx
Once you have the SPID of a blocking process, you can use DBCC INPUTBUFFER
to see what command it last executed.
http://msdn.microsoft.com/library/d...
v8y.asp
Here are a couple of articles on tracing deadlocks:
http://support.microsoft.com/defaul...kb;en-us;832524
http://support.microsoft.com/defaul...kb;en-us;271509
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>|||http://support.microsoft.com/defaul...kb;en-us;832524
Regards
Amish
*** Sent via Developersdex http://www.examnotes.net ***|||I think all the answers you are getting explain how to figure out what is
causing deadlocks so you can rewrite your applications to avoid them. While
this is definitely the right approach, you seem to be asking what you can do
to detect deadlocks in your code. SQL Server already detects and resolves
deadlocks for you. It does this by picking one of the transactions involved
in the deadlock and terminating it so the other transactions can continue.
The error you get at the client is saying that your transaction is the one
picked as the victim. The right thing to do when you're the deadlock victim
is to restart the transaction. If you have enough information available to
do the transaction again, you can just do it without telling the user that
something happened but if you need the user to re-enter the data to rerun
the transaction then just tell the user what happened and have them redo it.
Avoiding deadlocks through application design is important but in some cases
they are unavoidable and you should code your application to respond
appropriately.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Vikram" <aa@.aa> wrote in message
news:%23x95g36CGHA.2700@.TK2MSFTNGP14.phx.gbl...
> Is there any way by which deadlocks can be detacted and then appropriate
> action can be taken (in vb.net code or sql) to avoid it. instead of
> throwing
> error we can revoke the sp call..
> thanks
>

Detach and Attach functions in SQL Server 2005

Hi,

I'm trying to port my ASP.NET web application to the production system.

I'm connection to the SQL Server 2005 instance on my hosting server via CTP. I've uploaded the .mdf and .ldf files of my DB via FTP to the hosting server, and then tried to attach using this command:

use master gosp_attach_db'tgp','F:\webspace\disk20\db\TGP.mdf','F:\webspace\disk20\db\TGP_log.ldf' go

but then there is an error (obviously) stating that I don't have permissions to create a database in database master.

I must admit that I'm prettycluelessin this area. My hostingservicesalready created a "place holder" for my database (tgp), but I don't know how to proceed from here in order attach the database files in the production environment. Is this something I can do myself, or must I involve the hosting services?

Thanks,

Alon

sp_attach_db requires the same permissions as CREATE DATABASE - so you're likely not going to be able to do this (if so, let me know who your host is - I could use the free/extra space they'd let me set up *grin*).

You'll either need to contact them and have them hook up your DB, or look into using user-instance/attachable SQL Express functionality.|||

You have two options just backup your database and use management studio to restore your database on the host SQL Server after you have registered the host SQL Server in your management studio. In the backup and restore wizard choose the restore from device option. The other option is try the thread below for Attach database code modify it for your needs and use it. Hope this helps.

http://forums.asp.net/thread/981274.aspx

|||

Thak you for your reply.

I tried to backup/restore, but when I tried to point to the location of the backup file (on the remote server), got the error message that I'm not authorized... I've just sent a request from the hosting firm to handle this.

I have a general question: what are the guidelines when moving from the test/development system to the production system? I couldn't find any article summarizing the process.

Thank you,

Alon

|||You should only use a company that gives you access to management studio so you can use the backup and restore wizard because if you don't backup your database they will charge you to back it up. Here in the US most hosting company will give you the access. Hope this helps.|||

Yep, this helps

Alon

Detach & Attach Database

I've just created ASPNETDB database with ASP.NET Security. Now, I want to send this db to orther computer.First, I detached this db, then when I used attach database in that computer, there is an error :

Error 602: Could not find row in sysindexes for database ID 8, object ID 1, indext ID 1. RUN DBCC CHECKTABLE on sysindexes.

Please help me .Thank.

I guess you're trying to attach a database from SQL2005/Express to a SQL2000 instance. Since most system objects have been changed in SQL2005, you can't use a SQL2005 database in SQL2000. What you can do is to transfer database objects/data/schema from SQL2005 to SQL2000.

|||How I do ? Could you guide me step by step ! Thank.|||You can open VS2005->new an Integration Service Project->add a Transfer SQL Server Objects Task

desperately needing help with a Server Error

hey... i know NOTHING about sql server, .net framework or probably anything
else on sql monster. i am a novice access user, self-taught for about 9
months now and have only a basic understanding of vba. that being said, i
need some help...8)
i have a web site that i used to routinely visit for my job that performs
calculations for monthly car payments based on about 20 user-entered fields.
the problem is that about 3 months ago, it stopped working -- when you hit
the calculate button, the screen will seem to refresh as normal but either
nothing comes up in the monthly payment box, or if it's there, when you clic
k
the print button (and you HAVE to click this button as opposed to printing
right from internet explorer), the following error occurrs:
Server Error in '/' Application
.Net SqlClient Data Provider::Procedure'sp_MW_tblDeals_Updat
e_Main_Finance'
expects parameter '@.lp_mny_D_Selling_Price', which was not supplied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Stack Trace: (i will repost this if you need to see it -- it's a little
lengthy)
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NE
T
Version:1.1.4322.2300
Now, here's the weird bit. this is NOT a problem with the web site. it
isn't a problem with internet explorer (99%) or adobe. i know this because
if i log off of windows under my normal user id, and log in as admin, it wil
l
work. the admin id has minimal files, software, etc.. just like most pc's
i'm sure. i uninstalled the .net framework and reinstalled it using version
2.0 and i still get the same error identifying version 1.1.4322.2300. I hav
e
called tech support for this web site but they are useless, trying to have m
e
delete temp internet files and cookies and not much else. i have created a
new user id on this pc just to be able to use this web site (which despite m
y
slow pace at adressing this issue due to lack of company pressure has become
a hot-button for my bosses all of a sudden).
i apologize for the way in which this question was worded, if it even makes
sense at all. i tripped on to this board from access monster and thought it
a stroke of dumb luck, considering i had no idea of where to turn for help
with this. thanks for looking.
Greg
Message posted via http://www.droptable.com"kaosyeti@.comcast.net" <u15580@.uwe> wrote in message
news:6057106c0556f@.uwe...
> hey... i know NOTHING about sql server, .net framework or probably
> anything
> else on sql monster. i am a novice access user, self-taught for about 9
> months now and have only a basic understanding of vba. that being said, i
> need some help...8)
> i have a web site that i used to routinely visit for my job that performs
> calculations for monthly car payments based on about 20 user-entered
> fields.
> the problem is that about 3 months ago, it stopped working -- when you hit
> the calculate button, the screen will seem to refresh as normal but either
> nothing comes up in the monthly payment box, or if it's there, when you
> click
> the print button (and you HAVE to click this button as opposed to printing
> right from internet explorer), the following error occurrs:
>
> Server Error in '/' Application
> .Net SqlClient Data
> Provider::Procedure'sp_MW_tblDeals_Updat
e_Main_Finance'
> expects parameter '@.lp_mny_D_Selling_Price', which was not supplied.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Stack Trace: (i will repost this if you need to see it -- it's a little
> lengthy)
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300;
> ASP.NET
> Version:1.1.4322.2300
>
<snip>
The error means that the stored procedure named
sp_MW_tblDeals_Update_Main_Finance requires a certain input parameter
(@.lp_mny_D_Selling_Price) before it will work. This parameter was not set in
the web sites calling code. I suspect someone has changed either the stored
procedure code by adding a new parameter, or changed the web site calling
code by removing a parameter. All I can suggest is that you send the error
message to the web site administrator.
Good Luck
Ron.|||you believe this despite the fact that it works under a different user id on
the same pc?
Ron wrote:
>[quoted text clipped - 28 lines]
><snip>
>The error means that the stored procedure named
>sp_MW_tblDeals_Update_Main_Finance requires a certain input parameter
>(@.lp_mny_D_Selling_Price) before it will work. This parameter was not set i
n
>the web sites calling code. I suspect someone has changed either the stored
>procedure code by adding a new parameter, or changed the web site calling
>code by removing a parameter. All I can suggest is that you send the error
>message to the web site administrator.
>Good Luck
>Ron.
>
Greg
Message posted via http://www.droptable.com|||"kaosyeti@.comcast.net via droptable.com" <u15580@.uwe> wrote in message
news:6067051e82365@.uwe...
> you believe this despite the fact that it works under a different user id
> on
> the same pc?
>
<snip>[vbcol=seagreen]
<snip>
Well, that is what the error from .net sql client means. The error message
suggests a problem with the web site, but from what you say, it sounds as if
you may be having a windows permissions problem. Have you tried deleting the
user you have trouble with, and re-adding it? Can you try using a different
machine? Failing that, perhaps you could post the web site address, so we
could try it from here.
I am unsure what else to suggest that would help you.
Regards,
Ron.

desperately needing help with a Server Error

hey... i know NOTHING about sql server, .net framework or probably anything
else on sql monster. i am a novice access user, self-taught for about 9
months now and have only a basic understanding of vba. that being said, i
need some help...8)
i have a web site that i used to routinely visit for my job that performs
calculations for monthly car payments based on about 20 user-entered fields.
the problem is that about 3 months ago, it stopped working -- when you hit
the calculate button, the screen will seem to refresh as normal but either
nothing comes up in the monthly payment box, or if it's there, when you click
the print button (and you HAVE to click this button as opposed to printing
right from internet explorer), the following error occurrs:
Server Error in '/' Application
.Net SqlClient Data Provider::Procedure'sp_MW_tblDeals_Update_Main_Finance'
expects parameter '@.lp_mny_D_Selling_Price', which was not supplied.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.
Stack Trace: (i will repost this if you need to see it -- it's a little
lengthy)
Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET
Version:1.1.4322.2300
Now, here's the weird bit. this is NOT a problem with the web site. it
isn't a problem with internet explorer (99%) or adobe. i know this because
if i log off of windows under my normal user id, and log in as admin, it will
work. the admin id has minimal files, software, etc.. just like most pc's
i'm sure. i uninstalled the .net framework and reinstalled it using version
2.0 and i still get the same error identifying version 1.1.4322.2300. I have
called tech support for this web site but they are useless, trying to have me
delete temp internet files and cookies and not much else. i have created a
new user id on this pc just to be able to use this web site (which despite my
slow pace at adressing this issue due to lack of company pressure has become
a hot-button for my bosses all of a sudden).
i apologize for the way in which this question was worded, if it even makes
sense at all. i tripped on to this board from access monster and thought it
a stroke of dumb luck, considering i had no idea of where to turn for help
with this. thanks for looking.
--
Greg
Message posted via http://www.sqlmonster.com"kaosyeti@.comcast.net" <u15580@.uwe> wrote in message
news:6057106c0556f@.uwe...
> hey... i know NOTHING about sql server, .net framework or probably
> anything
> else on sql monster. i am a novice access user, self-taught for about 9
> months now and have only a basic understanding of vba. that being said, i
> need some help...8)
> i have a web site that i used to routinely visit for my job that performs
> calculations for monthly car payments based on about 20 user-entered
> fields.
> the problem is that about 3 months ago, it stopped working -- when you hit
> the calculate button, the screen will seem to refresh as normal but either
> nothing comes up in the monthly payment box, or if it's there, when you
> click
> the print button (and you HAVE to click this button as opposed to printing
> right from internet explorer), the following error occurrs:
>
> Server Error in '/' Application
> .Net SqlClient Data
> Provider::Procedure'sp_MW_tblDeals_Update_Main_Finance'
> expects parameter '@.lp_mny_D_Selling_Price', which was not supplied.
> Description: An unhandled exception occurred during the execution of the
> current web request. Please review the stack trace for more information
> about the error and where it originated in the code.
> Stack Trace: (i will repost this if you need to see it -- it's a little
> lengthy)
> Version Information: Microsoft .NET Framework Version:1.1.4322.2300;
> ASP.NET
> Version:1.1.4322.2300
>
<snip>
The error means that the stored procedure named
sp_MW_tblDeals_Update_Main_Finance requires a certain input parameter
(@.lp_mny_D_Selling_Price) before it will work. This parameter was not set in
the web sites calling code. I suspect someone has changed either the stored
procedure code by adding a new parameter, or changed the web site calling
code by removing a parameter. All I can suggest is that you send the error
message to the web site administrator.
Good Luck
Ron.|||you believe this despite the fact that it works under a different user id on
the same pc?
Ron wrote:
>> hey... i know NOTHING about sql server, .net framework or probably
>> anything
>[quoted text clipped - 28 lines]
>> ASP.NET
>> Version:1.1.4322.2300
><snip>
>The error means that the stored procedure named
>sp_MW_tblDeals_Update_Main_Finance requires a certain input parameter
>(@.lp_mny_D_Selling_Price) before it will work. This parameter was not set in
>the web sites calling code. I suspect someone has changed either the stored
>procedure code by adding a new parameter, or changed the web site calling
>code by removing a parameter. All I can suggest is that you send the error
>message to the web site administrator.
>Good Luck
>Ron.
>
--
Greg
Message posted via http://www.sqlmonster.com|||"kaosyeti@.comcast.net via SQLMonster.com" <u15580@.uwe> wrote in message
news:6067051e82365@.uwe...
> you believe this despite the fact that it works under a different user id
> on
> the same pc?
>
<snip>
>>The error means that the stored procedure named
>>sp_MW_tblDeals_Update_Main_Finance requires a certain input parameter
>>(@.lp_mny_D_Selling_Price) before it will work. This parameter was not set
>>in
>>the web sites calling code. I suspect someone has changed either the
>>stored
>>procedure code by adding a new parameter, or changed the web site calling
>>code by removing a parameter. All I can suggest is that you send the error
>>message to the web site administrator.
<snip>
Well, that is what the error from .net sql client means. The error message
suggests a problem with the web site, but from what you say, it sounds as if
you may be having a windows permissions problem. Have you tried deleting the
user you have trouble with, and re-adding it? Can you try using a different
machine? Failing that, perhaps you could post the web site address, so we
could try it from here.
I am unsure what else to suggest that would help you.
Regards,
Ron.

desperate for help! PLEASE!

I installed the reporting service and everytime I start a new porject in
visual studio .net, I get a message saying that it is unable to load the
RSReportDesigner.config file.
I can't find any help online and I can't get into the beta newsgroup...
HELP PLEASE.
Thanks.
EmadI found out what was the problem. The evaluation version does NOT work on
windows XP only 2000. Strange!!!!
-Emad
"Emad Ibrahim" <iemad@.nospam.hotmail.com> wrote in message
news:uOw3uKI4DHA.632@.TK2MSFTNGP12.phx.gbl...
> I installed the reporting service and everytime I start a new porject in
> visual studio .net, I get a message saying that it is unable to load the
> RSReportDesigner.config file.
> I can't find any help online and I can't get into the beta newsgroup...
> HELP PLEASE.
> Thanks.
> Emad
>

desperate for help! PLEASE!

I installed the reporting service and everytime I start a new porject in
visual studio .net, I get a message saying that it is unable to load the
RSReportDesigner.config file.
I can't find any help online and I can't get into the beta newsgroup...
HELP PLEASE.
Thanks.
EmadI found out what was the problem. The evaluation version does NOT work on
windows XP only 2000. Strange!!!!
-Emad
"Emad Ibrahim" <iemad@.nospam.hotmail.com> wrote in message
news:uOw3uKI4DHA.632@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I installed the reporting service and everytime I start a new porject in
> visual studio .net, I get a message saying that it is unable to load the
> RSReportDesigner.config file.
> I can't find any help online and I can't get into the beta newsgroup...
> HELP PLEASE.
> Thanks.
> Emad
>

---

Designing reports without Visual Studio .NET 2003

I'm really interested in Reporting Services, but I can't seem to find any
documentation on how to write reports and utilize it without Visual Studio
.NET 2003. Is there any way to do that?
--
Chris Shipley
HSI System Administrator
CAFCA, Inc.
Hartford, CT
http://www.cafca.org
chriss@.crtct.orgHere is some information.
http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
Chris Shipley wrote:
> I'm really interested in Reporting Services, but I can't seem to find any
> documentation on how to write reports and utilize it without Visual Studio
> .NET 2003. Is there any way to do that?
> --
> Chris Shipley
> HSI System Administrator
> CAFCA, Inc.
> Hartford, CT
> http://www.cafca.org
> chriss@.crtct.org
>|||Microsoft also have a sample app for creating RDL.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_tutorials_v1_02ua.asp
Combine this with the sample code for accessing the reporting services web
servic
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_002q.asp
With these two set of examples you can write a program to create rdl,
publish it to the web service and view it within an application. The
complexity will be trying to generate more complex reports as the sample
provided on msdn only generates simple rdl. Easiest way I found to start
writing code to generate more complex rdl was to use the sample RDL program
to generate a report, load this report in vs.net and make some changes then
compare the modified rdl with your original and retro-fit the changes in to
the code. With a lot of time (and hair pulling) you can ultimately generate
fairly complex RDL.
Hope this helps,
Richard
"Jerry" wrote:
> Here is some information.
> http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
>
> Chris Shipley wrote:
> > I'm really interested in Reporting Services, but I can't seem to find any
> > documentation on how to write reports and utilize it without Visual Studio
> > .NET 2003. Is there any way to do that?
> >
> > --
> > Chris Shipley
> > HSI System Administrator
> > CAFCA, Inc.
> > Hartford, CT
> > http://www.cafca.org
> > chriss@.crtct.org
> >
> >
>|||Hey, thanks for that! See, I have this huge database (1.3+ gb) with over
500 users, but there's no good reporting tool for them. I'm looking for a
way to give them a visual report writing tool, perhaps on the web secured
through SSL. But if they have to use VS.NET to create a report, its not
very cost effective.
Anyone out there know of any resources I can look at to achieve my
objective? I'd utilize SQL Reporting Services, but I don't have VS.NET
either. I suppose if I had to, I could learn RDL, but that doesn't seem an
effective method for users. Maybe someone out there is already writing a
VS.NET program for that purpose! :)
--
Chris Shipley
HSI System Administrator
CAFCA
Hartford, CT
Ph: 860-560-5455
http://www.cafca.org/helpdesk
chriss@.crtct.org
"Jerry" <JerryNY32513@.hotmail.com> wrote in message
news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> Here is some information.
> http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
>
> Chris Shipley wrote:
> > I'm really interested in Reporting Services, but I can't seem to find
any
> > documentation on how to write reports and utilize it without Visual
Studio
> > .NET 2003. Is there any way to do that?
> >
> > --
> > Chris Shipley
> > HSI System Administrator
> > CAFCA, Inc.
> > Hartford, CT
> > http://www.cafca.org
> > chriss@.crtct.org
> >
> >|||Several partners provide applications for RS 2000 that will allow the
creation of reports without using VS.NET. Some of them provide web-based
designers, some of them provide tools integrated e.g. into Office. You may
want to check:
http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
If you can wait till RS 2005, it will provide an additional report design
tool called "Report Builder". It is a stand-alone application (independent
of the VS.NET report designer) and is focused on end-users. It allows them
to easily create reports without needing to design queries or writing
expressions. Report Builder was briefly shown as one of the new features in
RS 2005 in this webcast:
http://msevents.microsoft.com/cui/eventdetail.aspx?eventid=1032263305&culture=en-us
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Shipley" <chriss@.crtct.org> wrote in message
news:%23HOyS7sBFHA.1408@.TK2MSFTNGP10.phx.gbl...
> Hey, thanks for that! See, I have this huge database (1.3+ gb) with over
> 500 users, but there's no good reporting tool for them. I'm looking for a
> way to give them a visual report writing tool, perhaps on the web secured
> through SSL. But if they have to use VS.NET to create a report, its not
> very cost effective.
> Anyone out there know of any resources I can look at to achieve my
> objective? I'd utilize SQL Reporting Services, but I don't have VS.NET
> either. I suppose if I had to, I could learn RDL, but that doesn't seem
an
> effective method for users. Maybe someone out there is already writing a
> VS.NET program for that purpose! :)
> --
> Chris Shipley
> HSI System Administrator
> CAFCA
> Hartford, CT
> Ph: 860-560-5455
> http://www.cafca.org/helpdesk
> chriss@.crtct.org
> "Jerry" <JerryNY32513@.hotmail.com> wrote in message
> news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> > Here is some information.
> >
> > http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
> >
> >
> >
> > Chris Shipley wrote:
> > > I'm really interested in Reporting Services, but I can't seem to find
> any
> > > documentation on how to write reports and utilize it without Visual
> Studio
> > > .NET 2003. Is there any way to do that?
> > >
> > > --
> > > Chris Shipley
> > > HSI System Administrator
> > > CAFCA, Inc.
> > > Hartford, CT
> > > http://www.cafca.org
> > > chriss@.crtct.org
> > >
> > >
>|||Thanks Robert.
Is there a beta version of RS 2005?
--
Chris Shipley
HSI System Administrator
CAFCA
Hartford, CT
Ph: 860-560-5455
http://www.cafca.org
chriss@.crtct.org
"Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
news:uN%23$chyBFHA.1452@.TK2MSFTNGP11.phx.gbl...
> Several partners provide applications for RS 2000 that will allow the
> creation of reports without using VS.NET. Some of them provide web-based
> designers, some of them provide tools integrated e.g. into Office. You may
> want to check:
> http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
> If you can wait till RS 2005, it will provide an additional report design
> tool called "Report Builder". It is a stand-alone application (independent
> of the VS.NET report designer) and is focused on end-users. It allows them
> to easily create reports without needing to design queries or writing
> expressions. Report Builder was briefly shown as one of the new features
in
> RS 2005 in this webcast:
>
http://msevents.microsoft.com/cui/eventdetail.aspx?eventid=1032263305&culture=en-us
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Chris Shipley" <chriss@.crtct.org> wrote in message
> news:%23HOyS7sBFHA.1408@.TK2MSFTNGP10.phx.gbl...
> > Hey, thanks for that! See, I have this huge database (1.3+ gb) with
over
> > 500 users, but there's no good reporting tool for them. I'm looking for
a
> > way to give them a visual report writing tool, perhaps on the web
secured
> > through SSL. But if they have to use VS.NET to create a report, its not
> > very cost effective.
> >
> > Anyone out there know of any resources I can look at to achieve my
> > objective? I'd utilize SQL Reporting Services, but I don't have VS.NET
> > either. I suppose if I had to, I could learn RDL, but that doesn't seem
> an
> > effective method for users. Maybe someone out there is already writing
a
> > VS.NET program for that purpose! :)
> >
> > --
> > Chris Shipley
> > HSI System Administrator
> > CAFCA
> > Hartford, CT
> > Ph: 860-560-5455
> > http://www.cafca.org/helpdesk
> > chriss@.crtct.org
> >
> > "Jerry" <JerryNY32513@.hotmail.com> wrote in message
> > news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> > > Here is some information.
> > >
> > >
http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
> > >
> > >
> > >
> > > Chris Shipley wrote:
> > > > I'm really interested in Reporting Services, but I can't seem to
find
> > any
> > > > documentation on how to write reports and utilize it without Visual
> > Studio
> > > > .NET 2003. Is there any way to do that?
> > > >
> > > > --
> > > > Chris Shipley
> > > > HSI System Administrator
> > > > CAFCA, Inc.
> > > > Hartford, CT
> > > > http://www.cafca.org
> > > > chriss@.crtct.org
> > > >
> > > >
> >
> >
>|||Yes, there is a Beta program for SQL Server 2005 (which includes RS 2005).
More information can be found here:
http://www.microsoft.com/sql/2005/default.asp
If you are a MSDN subscriber you should also have access to SQL Server CTPs
(Community Technology Previews). Report Builder is a completely new product
and not yet available in the December CTP, but it will be included in SQL
Server 2005 Beta 3 and very likely already in one of the upcoming CTPs.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Shipley" <chriss@.crtct.org> wrote in message
news:eApnSOMCFHA.328@.tk2msftngp13.phx.gbl...
> Thanks Robert.
> Is there a beta version of RS 2005?
> --
> Chris Shipley
> HSI System Administrator
> CAFCA
> Hartford, CT
> Ph: 860-560-5455
> http://www.cafca.org
> chriss@.crtct.org
> "Robert Bruckner [MSFT]" <robruc@.online.microsoft.com> wrote in message
> news:uN%23$chyBFHA.1452@.TK2MSFTNGP11.phx.gbl...
> > Several partners provide applications for RS 2000 that will allow the
> > creation of reports without using VS.NET. Some of them provide web-based
> > designers, some of them provide tools integrated e.g. into Office. You
may
> > want to check:
> > http://www.microsoft.com/sql/reporting/partners/softwareapps.asp
> >
> > If you can wait till RS 2005, it will provide an additional report
design
> > tool called "Report Builder". It is a stand-alone application
(independent
> > of the VS.NET report designer) and is focused on end-users. It allows
them
> > to easily create reports without needing to design queries or writing
> > expressions. Report Builder was briefly shown as one of the new features
> in
> > RS 2005 in this webcast:
> >
>
http://msevents.microsoft.com/cui/eventdetail.aspx?eventid=1032263305&culture=en-us
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Chris Shipley" <chriss@.crtct.org> wrote in message
> > news:%23HOyS7sBFHA.1408@.TK2MSFTNGP10.phx.gbl...
> > > Hey, thanks for that! See, I have this huge database (1.3+ gb) with
> over
> > > 500 users, but there's no good reporting tool for them. I'm looking
for
> a
> > > way to give them a visual report writing tool, perhaps on the web
> secured
> > > through SSL. But if they have to use VS.NET to create a report, its
not
> > > very cost effective.
> > >
> > > Anyone out there know of any resources I can look at to achieve my
> > > objective? I'd utilize SQL Reporting Services, but I don't have
VS.NET
> > > either. I suppose if I had to, I could learn RDL, but that doesn't
seem
> > an
> > > effective method for users. Maybe someone out there is already
writing
> a
> > > VS.NET program for that purpose! :)
> > >
> > > --
> > > Chris Shipley
> > > HSI System Administrator
> > > CAFCA
> > > Hartford, CT
> > > Ph: 860-560-5455
> > > http://www.cafca.org/helpdesk
> > > chriss@.crtct.org
> > >
> > > "Jerry" <JerryNY32513@.hotmail.com> wrote in message
> > > news:uvPSGLkBFHA.2568@.TK2MSFTNGP11.phx.gbl...
> > > > Here is some information.
> > > >
> > > >
> http://www.ReportingServicesFAQ.com/ow.asp?ReportingWithoutVisualStudio
> > > >
> > > >
> > > >
> > > > Chris Shipley wrote:
> > > > > I'm really interested in Reporting Services, but I can't seem to
> find
> > > any
> > > > > documentation on how to write reports and utilize it without
Visual
> > > Studio
> > > > > .NET 2003. Is there any way to do that?
> > > > >
> > > > > --
> > > > > Chris Shipley
> > > > > HSI System Administrator
> > > > > CAFCA, Inc.
> > > > > Hartford, CT
> > > > > http://www.cafca.org
> > > > > chriss@.crtct.org
> > > > >
> > > > >
> > >
> > >
> >
> >
>

Design question

We currently have an ASP.NET app that includes some reports. I'm
considering
making the data available in RS and I'm looking for some opinions
about
the feasibility and difficulty in doing this.
The app uses ODBC to connect to DB2. The users use their DB2 userid
and password, and this is what is used in the connection string.
The current solution includes a lot of manipulation of datatables
which are then bound to ASP.NET datagrids.
My thought was to create a web service that would serve as an RS Data
Extension, but I'm just taking a first look at this and don't know how
practical it would be. The idea is that the data retrieval and
manipulation logic could be in the web service, which would return a
dataset (or whatever).
The solution would have to include drilling down / linking to other
reports, so the userid and password would have to be maintained behind
the scenes so they could be passed, along with other parameters, to
the web service for each report/subreport.
Any thoughts are welcome.
TIA,
JimSounds like a winner to me :-). It doesn't have to be a web service of
course, you can write a data extension which would itself query your data
source and massage the data.
--
Hope this helps.
----
Teo Lachev, MCSD, MCT
Author: "Microsoft Reporting Services in Action"
Publisher website: http://www.manning.com/lachev
Buy it from Amazon.com: http://shrinkster.com/eq
Home page and blog: http://www.prologika.com/
----
"jim corey" <jhcorey@.yahoo.com> wrote in message
news:1c4f8dcf.0409210702.587ac17d@.posting.google.com...
> We currently have an ASP.NET app that includes some reports. I'm
> considering
> making the data available in RS and I'm looking for some opinions
> about
> the feasibility and difficulty in doing this.
> The app uses ODBC to connect to DB2. The users use their DB2 userid
> and password, and this is what is used in the connection string.
> The current solution includes a lot of manipulation of datatables
> which are then bound to ASP.NET datagrids.
> My thought was to create a web service that would serve as an RS Data
> Extension, but I'm just taking a first look at this and don't know how
> practical it would be. The idea is that the data retrieval and
> manipulation logic could be in the web service, which would return a
> dataset (or whatever).
> The solution would have to include drilling down / linking to other
> reports, so the userid and password would have to be maintained behind
> the scenes so they could be passed, along with other parameters, to
> the web service for each report/subreport.
> Any thoughts are welcome.
> TIA,
> Jim

design of a process

I'm going to design a web page for students parking permit application.I'm new to asp.net, I have a process in mind doing it like this:

The form asks student to choose a permit type, then fill in applicant info, like name, grade, vehicle info, student may have 2 vehicles, and payment method, check or credit card,

I plan to create 3 tables like tblPermit, tblapplicant, tblVehicle.

After the students fill in the form, click submit button, I pass the values and call a stored procedure, some thing like this.Dim CmdAsNew Data.SqlClient.SqlCommand(MySQL, MyConn)

Cmd.CommandType = Data.CommandType.StoredProcedure

Then in the stored proceudre, I will do :

Begin

insert into Permit table, then get permitID, by using something like this:

Select @.PermitID=@.@.Identity

Then insert into Student table,then use

Select @.StudentID=@.@.Identity

Then insert into vehicle table.

All the above 3 processes I put it in begin, end--So that they will not messed up with other applicants data.

I think begin...end is one transaction.

SO am I doing correctly this way? Thanks

Begin...End doesn't signify a transaction, it signifies a code block. The idea is basically correct, but use SELECT @.PermitID=SCOPE_IDENTITY() instead. You should also wrap the whole thing in a transaction to be safe.

|||

So shall I use something like this:

AS
Begin

Begin transaction
Set NoCount on
DECLARE @.PermitID INT
Insert table............

Commit Transaction

End

Can I use the begin transaction ...commit transaction in Begin ......end, or no need of begin..end.

Thanks

design ideas

I'm new to asp.net. Please help me with some ideas about the design of databases and interface of the web site.

We are a public school district, I want to create a website for families to go on line to update their family and student's demographic information. Basically I put the students' infomation pulled from our student information system software on the web, the parents can log in on line to update it at the beginning of school year. After that, I will create some report and let secretary manually do the update to our student information system.

The demographic infor includes 3 parts,

1. family street address, city, state, zip
2 guardian1 primary phones,second phone, emails. primary phones,second phone
3, student date birth, gender. may have multiple students in one family

But how can I track which field parents changed, shall I do it in programming in the web form, or later when I create some kind of reports. For I only want to pull students with the fields that updated and give them to secretary to update manully, and I don't want to generate a full report and let them compare which field is changed and then update, it will take them too much time.

Thanks much in advance

Hello anncao,

> how can I track which field parents changed

the exact implementation depends on your programming skills, so i'll be starting from a basic approach, which should anyway be enough in your scenario:

1) The database: to each field should be associated a flag field (say bit type), telling wether the field has been changed or not (say "street" and "street_changed"); also another flag field should be associated to the record as a whole, to tell if *any* of the fields has been changed (say "rec_changed"). These flags should default to 0 (zero), and be set to 1 when needed.

2) The input form: before any rendering, you should store current field values, possibly in ViewState; after postback and before writing to the database, you should compare each field with its orginal stored value, and set its associated flag field to 1 if it has changed; also you should set the record-level flag in case *any* of the fields have changed. Please note that you will be writing to the database only flags set to 1, and be sure not to overwrite flags already set to 1 even in case in the current postback the user has not changed them...

3) The report: your final report should query the database and retrieve only those records where the record-level flag is set to 1; also, it should show changed fields somewhere marked (say red) in case their associated flag is set to 1 (or you could just show changed fields, or anything; "readability" is what matters here).

Hope this is clear enough. Btw, you could optimize on the flags and make them a single integer field where you work bit-wise level, but if this is too much complexity for you, just don't bother about it, as there's no relevant optimization at this level. Just make the code "readable" as well... ;)

-LV

|||

Thank you very much, that's certainly a good idea. But I still feels hard. I'm new to asp.net, try to use visual web developer express to accomplish this, thinking use the 3 gridview for the 3 parts, and have a update button for each part. for student and family are in different tables.

Is there an easier way I can do it similarly in visual web developer.

or can i make a copy of the tables and then later to compare them? but don't know how to select those fields which are different? we only collect his at the beginning of school year.

Or can you suggest me a book that I can start with how to write those codes ?

I have some experience with VBA, but not asp.net.

Thanks

|||

Ignore my previous message, I will go with the way you suggested.

For example I have a family table.if I want to do the way as you described at your posting, do I need to create an object data source, and where shall I write the comparing code?

Thanks

Design Help – Access SQL Database behind a firewall from ASP .NET pages.

Hi,

I am new to internet development and would like some advice on the technology used to access a SQL database that sits on a network behind a firewall.

** ASP .NET Page ** -> ** Web Server ** -> ** FIREWALL ** -> ** SQL **

So to give an example; from an ASP .NET page on the internet, I would like to populate a DataGrid with the contents of a single table from a SQL database. The SQL database is sitting on our company network behind a firewall.

Could someone please explain / point me in the right direction in how the ASP .NET page / Web Server can securely access the SQL database.

Thanking you in advance
ScottThe firewall needs to allow SQL access between the WebServer and the SQL server. This is usually port 1433. Only requests initiated by the webservers IP should be allowed to get to the db server.

You could also put together some web services on SQL server to send back datasets through the firewall (assuming its running iis and the .net framework).

Then you would just need to open port 80 between the webserver and the sql server. The webservices we run on our db server required an encrypted key as part of all method calls to insure that only we can run them.

No matter which way you do it, your opening a hole in your firewall for communication to occurr between the two boxes.|||Mbanavige – thanks for your reply. Can I confirm my understanding??

Option 1.
The firewall opens port 1433 with an additional rule to only allow the IP address of the web server to communicate on port 1433. As such this allows web server code to create a connection string to SQL? How would I fully qualifying the connection string server property - <SQL Server NetBIOS Name><domain>??

Option 2.
Have a second web server (internal) running on the same box as the SQL server. The internal web server will host web services, which can be called from the external web server. This requires the opening of port 80. Further security is added with the use of an encrypted key required for all method calls. How is the encrypted key implemented?

Is there an industry preferred solution?

Is option 2 more secure against SQL attacks since SQL access is further controlled through the use of web services?

Thanking you again in advance for your replies.
Scott

Design For Loading Data Without Knowlged of Datatype or Column Count

I am loading data from an external source into SQL Server via ASP.NET/C#. The problem is that I do not necessarily know the data types of each column coming in, perhaps until a user tells the application, which might not occur until after the data is loaded. Also, I cannot anticipate the number of columns coming in. What would table design look like?

Would you use a large table with enough columns (e.g. Column1, Column2, etc.) reasonable enough to accomodate all the columns that the source might have (32?), and use nchar as the datatype with the plan to convert/cast when I use the data? Isn't the cast kind of expensive?

Does this make sense? Surely other foplks have run into this...

My thanks!

If you're doing what I think you're doing, you might want to use an EAV (Entity/Attribute/Value) table to store your data. The attribute table stores the column definitions. The entity table store the "row id"s. The value table stores the actual values and is of the form

Entity_id int

Attribute_id int

Value (string/whatever)

You can have multiple value tables for different data types, but I find that it's more trouble than it's worth. I've used this on several projects where the data being captured is set by the users at run time.

Design a Database for Daily News Network website

Hello..

I want to upgrade my website to asp.net 2.0 and I want to add a Daily news to website.
and 10 to 15 news will be added daily , so after a year we have almost 4000 entry in the database.

For designing this DB what is your advice on how to store news in database?
Is it better to create same tables for each year ? for example
tblNews_2005
tblNews_2006

Or just to make one table and have all news stored in that ? its gonna be huge after years , isnt that make any problems?

Thanks
Regards.

Nah, just use a simple table... SQL server is highly optimized for large tables. I suppose, however, that you will have a primary key there. Moreover, you should add good indexes in the table

|||

Thanks, I wonder , how large the table could be ? I have an archive of 40,000 records until now and it will be bigger every year.. Regards|||

I've seen sql server responding with the speed of light to one million records

And I've seen it responding poorly in 5000 rows (somebody had forgotten to use indexes...)

It's all to good database design, my friend!

|||

Thanks, so the size doesnt matter :D

The point is in a good design :)

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?