Cannot transfer schemabound object - error


  • I am trying to alter the AdventureWorks database to transfer ownership from one schema to another...

    Alter schema dbo transfer Person.CountryRegion

    I get the following error..

    "Cannot transfer a schemabound object."

    Any help would be appreciated.
    Monday, November 06, 2006 6:51 PM


  • Person.CountryRegion has foreign key references and an indexed view referencing it. So you need to resolve those before trying to transfer ownership. In this case, it looks like you have to drop the index on the view, perform the transfer and create the index back.
    Monday, November 06, 2006 10:54 PM