Alter schema dbo transfer Person.CountryRegion
I get the following error..
"Cannot transfer a schemabound object."
Any help would be appreciated.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.
No comments:
Post a Comment