Re: Different version of SQL Server returns different Result

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

From: Rick White (name=rick_at_domain=whiteconsulting.TLD=biz)
Date: 05/18/04 

Date: Mon, 17 May 2004 22:04:48 -0700

can you show some of the procedure? and give some more detail about what
you did when it did work, and what happened when it didn't? also, a link to
the internet information you saw?

"MaxLen" <anonymous@discussions.microsoft.com> wrote in message
news:AB441944-7978-4CA4-AB71-71901931A29D@microsoft.com...
> I have a stored procedure that is created and located at SQL Server 6.5.
When the stored procedure's result is invalid, it will return NULL, else it
will return 10++ characters in alphonumeric form.
>
> When I executed it at Query Analyzer for SQL Server 6.5, it is working
fine.
>
> The problem is, when I tried to execute it at Query Analyzer for SQL 2000,
it does not return as it should be. The result does not same as it is
executed at SQL Server 6.5, although both the inputs are correct.
>
> Furthermore, I try to create a application using VB, to execute the stored
procedure. The outcome is same.
>
> Since both SQL Server 2000 and VB do not provide the result as it is
executes at SQL Server 6.5, I found out some information on the internet,
that some faulty when SQL Server 6.5 tries to return NULL value. Thus, I
changed the store procedure. It will return "0", when the stored
procedured's result is invalid.
>
> But the problem is, it happen again.
>
> I really your help urgently.
>
> Thanks.
>

Relevant Pages

  • Where the !@?!@ is my Stored Procedure?
    ... I wrote the following in the SQL Server 2005 Express Management Studio ... and hit execute. ... Even though Query Analyzer indicated success when I ... to execute the code again, and lo and behold, SQL Server gives me the ...
    (comp.databases.ms-sqlserver)
  • Re: IE6 on Windows Server 2003 BROKEN
    ... I recall that I recently installed WMI SQL Server ... > Provider from the SQL Server 2000 install disk in an attempt to automate ... > and disappeared; all connections are invalid. ... > execute." ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Execute Persmission denied on object sp_OACreate
    ... > SQL Server is creating a job behind the scenes. ... > permissions. ... > SA account password and gaining access to the database. ... >>> How can get a user permissions to execute these stored procedures ...
    (microsoft.public.sqlserver.security)
  • RE: exec sp_help_job user account rights
    ... wrapper in which u can call original stored procedure sp_help_job using “WITH ... EXECUTE AS “ clause and then give execute permission of external stored ... Database Administrator, SQL Server 2005 ... the sysadmin fixed role can use sp_help_job to view only the jobs he/she owns. ...
    (microsoft.public.sqlserver.security)
  • Re: SSIS - OLE DB Command - how to retrieve query results ???
    ... my side according to your process, and I managed to execute the task. ... Data Destination: <My SQL Server 2005 Instance>.TestDB ... OLE DB Command: ...
    (microsoft.public.sqlserver.dts)