• anthony.green (1/10/2013)


    Any references to that table will break once the name is changed, so things like views, functions, procedures etc will need checking to see if they reference the table in anyway.

    The sys.sql_modules table will be a very good place to start by quering the definition column for the table name in question.

    So, you are saying I have change any references to this table (like views, functions, procedures etc) manually?

    SueTons.

    Regards,
    SQLisAwe5oMe.