Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Gbkmut Views 1

Status
Not open for further replies.
DrRich10

DrRich10

IS-IT--Management
Apr 26, 2013
6
US
Macola ES 9.6.200 with SQL Server 2008 R2

Our database is starting to get bloated with views that Macola is creating that are named with the time and either GbkmutDbCrVIEW or GbkmutGLVIEW. Are these views required to be retained, and if not is there a way to have Macola remove them?

Thanks.
 
Sort by date Sort by votes
They are not required - and yes the GBKMUT views (along with all of the other temporary views, sp's and tables) are a nuisance.

I typically use a SQL script scheduled to run each evening to clear them out.

Peter Shirley
Macola Consultant, PA and surrounding states.
 
Upvote 0 Downvote
Thanks Peter. That's what we did with the temp tables, so I'll guess we'll do that with the temp views too. Just seems odd that these are created and stored forever when they are never used again.

Rich.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Fishhead714
  • Locked
  • Question
GBKMUT 1
Replies
2
Views
221
Fishhead714
Fishhead714
ChrisP520
  • Locked
  • Question
Orders Not Showing in views
Replies
7
Views
403
MacolaHelp
MacolaHelp

Part and Inventory Search

Sponsor

Back
Top