Re: SQL Server 7.0 8k rowsize limit

From: SS (sshah90_at_hotmail.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 15:30:52 -0500

Yes , the tables are the same with the same data. we are using crystal
reports to run the query. When I said it comes back with 2000 rows but no
data, I should have mentioned that when I run the query in Query analyzer it
comes back with the above message. Also let me specify we are using a view
that joins about 19 tables to run the query. Crystal reports also comes back
with empty reports but no error messages. We were running it on SQL Server
7.0 SP2. As soon as I installed SQL Server 7.0 SP4 and ran the query I got
the following error message(both in crystal and Query Analyzer)
"SqlDumpExceptionHandler: Process 9 generated fatal exception c0000005
EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process."
Thanks
Shah

"Kalen Delaney" <replies@public_newsgroups.com> wrote in message
news:OWVsyO5jEHA.2680@TK2MSFTNGP15.phx.gbl...
> Hi Shah
>
> There is no difference between the rowsize limits in 7.0 and 2000.
> Your (very limited) problem description does not sound like a problem with
> rowsize. What makes you think the problem is the rowsize?
> If the rows were too big they would never be inserted at all, and you
would
> have gotten error messages much earlier.
>
> Can you provide more details? Are you sure the tables are exactly the same
> with the same data, and running the same query?
> What tool are you using to run these queries? What do you get when you
run
> them through Query Analyzer?
>
> --
> HTH
> ----------------
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
>
> "SS" <sshah90@hotmail.com> wrote in message
> news:u%23gHkK5jEHA.1652@TK2MSFTNGP09.phx.gbl...
> > Hi,
> > Is there anyway to override the 8k rowsize limit in SQL Server 7.0
> service
> > pack 4.0. I have a Query with several nvarchar fields. The same query
runs
> > fine in SQL Server 2000. In SQL 7.0 it will return the message 2000 rows
> > affected but there is no data. Is there anyway to bypass this problem,
we
> > need a solution for SQL 7.0 as we have clients with SQL 7.0
> > Thanks
> > Shah
> >
> >
>
>

Relevant Pages

  • Re: ADP Help
    ... And the stored procedure would be something like: ... > this, if all the SQL statements are on the SQL Server, how would the SQL ... I use that query as a base ... >>> query for almost all of my reports. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cannot execute through ISQL
    ... Without any error messages, it is difficult to predict what's going on, but ... Here is the command and query.. ... SQL Server 2000 SP3, which is in WAN. ... >Vyas, MVP ...
    (microsoft.public.sqlserver.clients)
  • Re: Promt user for criteria ?
    ... >faster that a passthrough query from my front end which is access. ... I have read reports claiming that Access will fetch a complete linked ... (to a SQL Server table or view) ... Hugo Kornelis, SQL Server MVP ...
    (microsoft.public.sqlserver.mseq)
  • Re: Newbie? Do I use Report or Query
    ... <<what I really want is a conceptual model of how forms, queries and reports ... Reports are the counterpart of Forms. ... If based on a query, ... JobCard and JobDetails tables showing the fields in each for further ...
    (microsoft.public.access.gettingstarted)
  • Re: SQL Server 7.0 8k rowsize limit
    ... I am still not clear on why you think this has anything to do with rowsize ... > reports to run the query. ... > with empty reports but no error messages. ...
    (microsoft.public.sqlserver.programming)