Setup a SQL Job to execute the following TSQL against your Blackbaud NetCommunity Database on regular intervals:



exec dbo.spStats_UpdateStatistics
For more information regarding the creation of SQL Jobs please see the links below:



SQL Server 2005:

http://technet.microsoft.com/en-us/library/ms187910(SQL.90).aspx



SQL Server 2008:

http://technet.microsoft.com/en-us/library/ms187910.aspx

Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites, and we cannot assist in implementing the solutions on these websites.


Please contact the appropriate software vendor or IT professional for assistance with this process or issue, which is beyond Blackbaud's scope of support.