[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

'Ghost' Sqr Procedures



Hi, I'm new to this list so please excuse me if this question has been asked
(and answered) before though I have checked through the archives and not
found anything.

We are running sqr 3.0.7.0.1 on Sybase System 10 and have several reports
which are kicked off at regular intervals but they seem to be leaving
'ghost' stored procedures in the database.  When I try to drop the
procedures, I get a message saying they do not exist in the system
catalogues.

So, I have two questions:  how do these procedures get left in the database
after the report has been run, and (more importantly!), how do I get rid of
them?  I have almost 1000 now so need to do something quick.

Thanks in advance