Post reply

sp_updatestats error

  • January 17, 2005 at 11:20 am

    #84670

    I ran into a problem with my weekly sp_updatestats job.  I recieved an error stating that

    Server: Msg 169, Level 15, State 2, Line 2

    A column has been specified more than once in the order by list. Columns in the order by list must be unique.

    I was able to narrow down to the specific table where the sp_updatestats is failing but how do I find the specific procedure code that's causing this error.

    Thanks

  • January 17, 2005 at 9:04 pm

    #537767

    Did you run index tuning wizard. If you would have run that and in the meanwhile if it got interrupted. It would have created hypothetical indexes pertaining to your table.

    sp_helpinex 'your table name'

    list all indexes with the names start with "hind_%"

    Then use

    DROP INDEX tablename.indexname

    Else the other way around make use of this script. I would suggest this is safer . Follow the url

    http://support.microsoft.com/kb/q293177/

     

    Thanks,

    Ganesh

     

     

  • January 18, 2005 at 7:01 am

    #537823

    That did it.  Thanks so much.

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

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