Skip to Content
0
Former Member
Oct 25, 2011 at 10:12 AM

dbo.ImportTemp<n> tables

27 Views

Hi Gurus,

I notice that my AppSet database is getting stray tables called dbo.ImportTemp<random number> which are obvioulsy leftovers from data imports.

Can anyone enlighten me:

1.) as to why these tables get left behind and don't get automatically cleared.

2.) Is there a way I can set up housekeeping to automatically check for & clear them <yes, I know I can use a Stored Proc & get the info from systables, but I'm hoping there's a BP method> ...

Thanks