Post reply

Generating a UPDATE STATS for specific tables only

  • December 31, 2008 at 8:59 am

    #217041

    I am attempting to generate an update stats for all tables with scheduleday in it and having problems.... the with sample makes the query fail and the a, has to be there to get the query to be syntax correct but it doesn't do anything..... Any help would be appreciated.

    SELECT 'UPDATE STATISTICS dbo.' a,table_name 'WITH SAMPLE 50 PERCENT'

    FROM INFORMATION_SCHEMA.TABLES

    where table_name like '%ScheduleDay%'

  • December 31, 2008 at 9:16 am

    #919713

    try this

    SELECT 'UPDATE STATISTICS dbo.'+ table_name +' WITH SAMPLE 50 PERCENT'

    FROM INFORMATION_SCHEMA.TABLES

    where table_name like '%ScheduleDay%'

  • December 31, 2008 at 9:25 am

    #919719

    Thats it ! Thanks... I knew I was missing something. (Brain Cramp) It is one of those trying this and that and just needed someone else to look at it.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply