Post reply

Error while executing update stats maintenance plan

  • July 20, 2011 at 8:48 am

    #254682

    Hi All,

    I have restored SQL Server 2000 bakup on SQLServer 2008R2(10.50.1600).When i scheduled my maintenance plan for update statisstics for all user databases i get the following error.

    Executing the query "UPDATE STATISTICS [dbo].[*] W..." failed with the following error: "The CLR type referenced by column "*" of table variable "dbo.*" has been dropped during the execution of the batch. Run the batch again.

    any kind of help will be appreciated.

    Thanks

    Akshay

  • July 20, 2011 at 12:09 pm

    #1355928

    Check if you have User defined data types in this DB. That could be why you are ggeting this error

    -Roy

  • July 21, 2011 at 4:41 am

    #1356250

    Hi roy,

    yes there are some user defined datatypes.can you please explain how they are affecting my update statistics maintenance plan??

    Thanks,

    Akshay

  • July 21, 2011 at 6:56 am

    #1356323

    When you restored the 2000 database into SQL 2008, it did not recognize the user defined type. You probably might get a 6261 error when selecting from the table that has user defined type column in it.

    One way to fix this is to set the right data type. Alter the table and set the right data type.

    -Roy

  • July 22, 2011 at 3:06 am

    #1356895

    Hi Roy,

    Yes i am getting 6261 error on particular column.Thanks for reply.I will make some changes & will contactyou in case of any queries.

    Thanks

    Akshay

Viewing 5 posts - 1 through 4 (of 4 total)

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