by Lorenz Meye » Fri, 24 Nov 2000 16:40:10
Greetings Lorenz
by René Pederse » Fri, 24 Nov 2000 04:00:00
Quote:> After executing a SP, which uses cursors, I retrieve the message that the
> object of the cursor already exists, even
> if I made a "Deallocate cursorname". This message only appears on
> MSSQLServer 2000. On MSSQLServer 6.5, I retrieve a message, that the
> DB-Library process has been cancelled.
> What could be the reason!
> Greetings Lorenz
1. Can't change a stored procedure because it creates objects that already exist
Hi there,
I've been handed an existing stored procedure.
I need to add a single line to it.
Within the stored procedure, simple tables and tables
with indexes on them are created.
When I make my small change, it won't let me recreate
the procedure because those tables already exist in
the database.
How do I make my small change to it? Do I have to
rename all the tables and indexes, make my change and
then recompile it or do something else?
PLEASE HELP.................THANKS!!!!!!!!!!!!
2. Queries on a Fox Pro DBF file resting on a UNIX machine
3. Failing cursors exiting procedures
4. Why are Extraction, Transformation, and Loading Tools needed?
5. Determining if a stored procedure is already running.
6. Memory Usage
7. setting up stored procedure so it will not launch if it is already running
8. loading files into Oracle LONG
9. Stored Procedure prematurely exiting
10. stored procedure exits in the middle of its run
11. Stored procedure exit without any error message
12. @@ERROR resets when exiting stored procedure with non-empty return value
13. How to return data from Stored Procedure before exiting