Post reply

Is there a way to use sp_autostats databasename..tablename

  • January 2, 2007 at 4:57 pm

    #118492

    Hello,

    I would like to find out if I can use sp_autostats in a procedure and pass the database name:

    EXEC SP_AUTOSTATS databasename..tablename!!! This is not working!!

    It does work if  used only with tablename.

    Question is: can this be done? and if not  is there any other table that I can check for the status of statistics?

     

    Thanks for you help.

  • January 2, 2007 at 6:28 pm

    #680881

    How about

    EXEC databasename.dbo.sp_autostats tablename

     

    And then again, I might be wrong ...
    David Webb

  • January 3, 2007 at 9:24 am

    #680988

    Thanks David. It works

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

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