We have added search box. Key in SAP issue keyword to search
Home
About
Site Archive
SAP Chat
Contact
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-basis] Turning off automatic updates statistics for table VBMOD

Posted by Admin at
Share this post:
 Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

0 Comments

Posted by Patrick Yu
on Jul 26 at 4:47 AM 		Mark this reply as helpfulMark as helpful
i have try to add EXEC sp_autostats VBMOD, 'OFF' in SQL 2005, but it keep have query error with

Input name 'VBMOD' does not have a matching user table or indexed view in the current database.


---------------Original Message---------------
From: larg3n
Sent: Monday, May 10, 2010 2:47 PM
Subject: Turning off automatic updates statistics for table VBMOD

> Hello,
>
> I turned off automatic updates statistics for table VBMOD per SAP's note 771352 with my EWA report. But every time we reboot it turns back on automatically. I use EXEC sp_autostats VBMOD, 'OFF' within SQL 2005 to turn it off.
>
> Is there a ways to make this setting permanent?
>
> Thanks,
> Donald Largen

__.____._
Copyright © 2010 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
In the Spotlight
Earn Recognition for Your Contributions at Toolbox for IT. Gain Points for Community Achievements
_.____.__

 

0 comments:

Post a Comment

Post a Comment

Subscribe to: Post Comments (Atom)

T r a n s l a t e to your language