Re: 'Ghost' Sqr Procedures

[Beverley Childs <bdc@MFLTD.CO.UK>]

Thank you very much - dropproc worked beautifully!  I now need to research
how the reports are not terminating properly.

                -----Original Message-----
                From:   Juan Alvarado [mailto:juan@GYSSA.COM.GT]
                Sent:   22 June 1998 15:44
                To:     Multiple recipients of list SQR-USERS
                Subject:        Re: 'Ghost' Sqr Procedures

                Beverley:
                when a report sunddenly break up or dont terminate normaly
then the sqr
                SP. dont delete.  For delete this SP, you need the exactly
name to
                deleted.  The name you see its the the extacly name if you
do a sp_help
                then you see a name like SQR__1234 ,but the extacly name its
listed in
                sysobjects and its like this SQR__12345678890102. Or if you
run a sqr
                named dropproc.sqr its delete this SP.

                I hope this help.

                Juan Manuel Alvarado
                CPS-DBA Sybase XI
                Gerencia & Sistemas Guatemala
                www.gyssa.com.gt

                > -----Original Message-----
                > From: Beverley Childs [SMTP:bdc@MFLTD.CO.UK]
                > Sent: Sunday, June 21, 1998 2:20 PM
                > To:   Multiple recipients of list SQR-USERS
                > Subject:      '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