Database size on IIS 5

Good Morning,
I have a web service developed using vb.net. The web
service returns xml from selected data (SQL SELECT
statement using XML AUTO) from SQL Server. The web service
runs properly on smaller databases on both IIS 5 (Windows
2000 Server) and IIS 6 (Windows 2003 Server), but returns
an error when run against larger databases on IIS 5. The
error has been 'out System.OutOfMemoryException'.
I am trying to figure out the difference between IIS 5 and
IIS 6 which is causing this, and a solution.I guess the database is too big for IIS5, so it can not run.
After all, when IIS5 design, no one can image a big database like we use
today.
I think If I am you, I will catch this exception and give the customer some
information to update the IIS.
Last: This is a problem of IIS, you may ask there

Database size on IIS 5

Good Morning,
I have a web service developed using vb.net. The web
service returns xml from selected data (SQL SELECT
statement using XML AUTO) from SQL Server. The web service
runs properly on smaller databases on both IIS 5 (Windows
2000 Server) and IIS 6 (Windows 2003 Server), but returns
an error when run against larger databases on IIS 5. The
error has been 'out System.OutOfMemoryException'.
I am trying to figure out the difference between IIS 5 and
IIS 6 which is causing this, and a solution.I guess the database is too big for IIS5, so it can not run.
After all, when IIS5 design, no one can image a big database like we use
today.
I think If I am you, I will catch this exception and give the customer some
information to update the IIS.
Last: This is a problem of IIS, you may ask there:)

Database Schema Export as XML

I am trying to export the schema of an existing SQL Server Database to
an XSD File so it can be then used in an XML Dataset for reporting
purposes in Visual Studio .NET.
If there is a way this can be done any help would be appreciated.
Many Thanks
Stuart
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Hi Stuart
(just posted something myself and noticed yours...)
can you select from each table/view/etc. using the 'for xml auto
(,whatever)' and save the output to a file?
(I do this all the time from MS Access as a passthru query to SQL Server,
which doesn't do the 255 char truncating like SQL Server does. Next I either
copy and paste into a file, save as, etc.)
lastly, there's an XSD Interference download and online utility (either on
gotdotnet.com or asp.net that'll let you process the file to generate your
XSD). its rough, but the other approach I could recommend is considerably
more difficult (would have to yank big chunks of a 'database clone' sproc I
have to get it down to something usable.)
Rob
"Stuart Ferguson" wrote:

> I am trying to export the schema of an existing SQL Server Database to
> an XSD File so it can be then used in an XML Dataset for reporting
> purposes in Visual Studio .NET.
> If there is a way this can be done any help would be appreciated.
> Many Thanks
> Stuart
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
>

Database Schema Export as XML

I am trying to export the schema of an existing SQL Server Database to
an XSD File so it can be then used in an XML Dataset for reporting
purposes in Visual Studio .NET.
If there is a way this can be done any help would be appreciated.
Many Thanks
Stuart
*** Sent via Developersdex http://www.codecomments.com ***
Don't just participate in USENET...get rewarded for it!
Hi Stuart
(just posted something myself and noticed yours...)
can you select from each table/view/etc. using the 'for xml auto
(,whatever)' and save the output to a file?
(I do this all the time from MS Access as a passthru query to SQL Server,
which doesn't do the 255 char truncating like SQL Server does. Next I either
copy and paste into a file, save as, etc.)
lastly, there's an XSD Interference download and online utility (either on
gotdotnet.com or asp.net that'll let you process the file to generate your
XSD). its rough, but the other approach I could recommend is considerably
more difficult (would have to yank big chunks of a 'database clone' sproc I
have to get it down to something usable.)
Rob
"Stuart Ferguson" wrote:

> I am trying to export the schema of an existing SQL Server Database to
> an XSD File so it can be then used in an XML Dataset for reporting
> purposes in Visual Studio .NET.
> If there is a way this can be done any help would be appreciated.
> Many Thanks
> Stuart
> *** Sent via Developersdex http://www.codecomments.com ***
> Don't just participate in USENET...get rewarded for it!
>