Question Status

Unanswered
Mike Bailey asked a question on 29 Mar 2012 12:25 PM

We're using GP 10, and I'm doing some database clean up and notice hundreds of tables and stored procedures that named in the format of dbo.zDP_xxx_n, where 'xxx' is a "regular" table name, and 'n' is a number, or iteration. For example, I see these tables:

dbo.zDP_RM00101F_1,  dbo.zDP_RM00101F_2,  dbo.zDP_RM00101F_3,  dbo.zDP_RM00101F_4,  dbo.zDP_RM00101F_5,  dbo.zDP_RM00101F_6, dbo.zDP_RM00101F_7,  dbo.zDP_RM00101F_8

What are these and where do they come from?  Are they all needed? Can they be cleaned up somehow?

Thanks,

Mike Bailey

Reply
Victoria Yudin responded on 30 Mar 2012 5:23 AM

Mike,

If you are seeing tables with names starting with zDP that sounds wrong.  I would expect all the SQL objects staring with zDP to be stored procedures.  The default company database installation will have over 20,000 stored procedures, this is normal.  Here is a blog post explaining what these do in more detail: blogs.msdn.com/.../what-do-the-zdp-auto-generated-stored-procedures-do.aspx.  

Reply
Mike Bailey responded on 30 Mar 2012 5:44 AM

Thanks Victoria.  I went back and looked and you are correct, these are only Stored Procedures, and not tables, and I have 24,442 of them. As long as this is normal, then okay.

Thanks agian,

Mike Bailey

Reply