MS-SQL Server 2008 Update Statistics

[Former Member]

Hi,

We have SAP running on MS-SQL 2008. Can we use the command 'sp_updatestats' to update stats on all tables in the schema or is there any option we can schedule a job from DBACOCKPIT?

Thanks,

Kris

[Former Member]

Yes, you can use sp_updatestats as described here [MS173804|http://msdn.microsoft.com/en-us/library/ms173804.aspx] with MS SQL Server 2008.

I do not believe you can create the job from DBACOCKPIT, however.