SQL 2000 Stored Procedure Problem

Yesterday I spent hours searching the groups for a solution to this problem with no luck.

The issue is that a VB6 app I inherited has been running fine for years on SERVER1 (Server 2003 and SQL Server 2000). We moved the Database to a new SERVER2 (Server 2003 and SQL Server 2000) . The app has a mix of pass through SQL statements and I was in the process of converting them all to Stored Procedures. Five of the 14 routines have been converted to Stored Procedures. On SERVER1 all work fine.

On SERVER2 only the pass through routines work. Any that use Stored Procedures failed. I then wrote a simple Stored Procedure that returned just a text string - that worked - so it is not just a Stored Procedure problem . But as soon as I added a temp table to that "simple" Stored Procedure - it fails to return anything. All 5 of the production routines that fail use Temp tables.

I have tried every combination of permissions settings I could find and nothing seemed to work.

Anyone have any ideas here ?

Thanks!!

Relevant Pages

  • Re: OT: Renter of property in foreclosure
    ... related) and I've spent all week searching, unsuccessfully, for answers. ... a mortgage payment. ... The bank is not worried about any equity the current owner may have, ...
    (alt.vacation.las-vegas)
  • Re: Fritz Lahmann Conduts Dvorak
    ... the record in both files, The Vegh Qrt Brahms 1st qrt. ... in any case archive.org has the files, but searching seems ... Good luck. ... Rolf, what's this McGreevy business? ...
    (rec.music.classical.recordings)
  • Re: Is (s)earch linked to an ability?
    ... Along with luck. ... that wisdom would make searching easier. ... searching easier - aside from lenses. ...
    (rec.games.roguelike.nethack)
  • No PS2/USB/Serial Mouse from a clean install!
    ... parts from her older system [optical, drives, etc] and ... Tried searching via Add/Find Hardware, no luck. ... I'm really stumped because this is a clean install - i ...
    (microsoft.public.win2000.hardware)
  • Re: OT: Renter of property in foreclosure
    ... related) and I've spent all week searching, unsuccessfully, for answers. ... Your landlord has been collecting the money, ... Mortgage companies don't usually want to be landlords. ...
    (alt.vacation.las-vegas)
Quantcast