Monday, February 20, 2012

Loads of System Generated Procedures In publisher

Dear Friends,
I have a database which is a published for 3 subscriber with bit of
variations. now while checking i found that there are 8870 system generated
procedures in the database with name.
ap_sel_0394BA4C0A144B4DB88E9E00ED0446B3_pal or similar way.
please suggest do i need the same.
Can i clean this? How?
Best regards
Sharad
Dear Paul,
Thanks. You have guide me several times i salute you for the knowledge you
have.
now with the query you have given i got the results of 56 rows but there are
8000+ procedure do i need to delete the rest.
Thanks and best regards
Sharad.
"Sharad2005" wrote:

> Dear Friends,
> I have a database which is a published for 3 subscriber with bit of
> variations. now while checking i found that there are 8870 system generated
> procedures in the database with name.
> ap_sel_0394BA4C0A144B4DB88E9E00ED0446B3_pal or similar way.
> please suggest do i need the same.
> Can i clean this? How?
> Best regards
> Sharad

No comments:

Post a Comment