Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Cannot transfer a schemabound object

Author  Topic 

wgpubs
Yak Posting Veteran

67 Posts

Posted - 2007-06-19 : 19:36:32
Working with the AW sample database ... trying:

ALTER SCHEMA dbo
TRANSFER Production.Product

Getting the exception:
"Cannot transfer a schemabound object."

Help :)

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-20 : 11:10:01
Unbound the object first.
Go to Top of Page

wgpubs
Yak Posting Veteran

67 Posts

Posted - 2007-06-20 : 12:58:01
Ok wise guy ... how do you do that?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-20 : 13:37:00
Modify or recreate schema binding object.
Go to Top of Page

wgpubs
Yak Posting Veteran

67 Posts

Posted - 2007-06-20 : 14:16:02
where do you do that?
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-06-20 : 16:29:56
In ssms or query windows.
Go to Top of Page
   

- Advertisement -