RE: SQL Sate: 22012

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 01/27/05 

Date: Thu, 27 Jan 2005 12:57:01 -0800

Can you trace which statement is causing the error?

AMB

"dev-dba in distress on the prod side" wrote:

> I'm using SQL 2k, Crystal 9. Restored same database on two servers. Run a
> stored proc that executes the same query. One server returns no records (as
> there are none expected), the other throws a 'Failed to open a rowset SQL
> State: 22012' error, implying divide by zero error, but:
>
> a.) if there are no records, why would it divide by zero
> b.) why wouldn't the result be the same on both servers
>
> In other words, is there a flag or setting that one instance may have that
> would be disregarding that particular type of error?
>
> Thanks in advance,
> SThompson

Relevant Pages

  • Re: Weird performance issue ....
    ... If I understand - the problem is with a query returned from a stored proc ... "a query making a user function call" you mean something different again). ... as PL/SQL is assumed to be a "batch" environment. ... Not taking about power since where the issue is, the server ...
    (comp.databases.oracle.server)
  • Dont understand the performance issue with this simple query.
    ... I have a simple query that takes more than a minute to process, ... When I hard code the parameter value into the query, ... executes in less than one second. ... I am joining between a view on a linked server and a view on the local ...
    (microsoft.public.sqlserver)
  • Re: Deadlock problem on the 2005 Server
    ... finished doing it's job before the INSERT query wants to kick in. ... If another session executes this script at the same time, you may get a deadlock. ... I have this transaction what I want to execute on the MSSQL Server ...
    (microsoft.public.sqlserver.server)
  • osql output permissions problem
    ... I have a SQL scheduled task that executes a statement similar to this: ... Nothing fancy, just running a stored proc and sending the output to a ... a folder on another server on the network. ...
    (microsoft.public.sqlserver.server)
  • Re: Click link to go to routine
    ... the user gets to a URL that goes to server ALPHA ... That web server executes perl program A.pl which includes ... Server BETA executes perl program B.pl which looks at the information ... the browser sent, and executes a specific function inside the B.pl program. ...
    (comp.lang.perl.misc)