When OrcsWeb says they do Managed Windows Server Hosting, they really mean it. As part of that managed hosting, they often engage in beta programs and include their clients so that both the OrcsWeb staff and the end-users can get familiar with certain products prior to the release. One such product is Microsoft SQL Server 2012 (aka Denali), and an example of the type of troubleshooting and assistance provided is reflected below…
We ran into a situation today where we needed to change the owner of a table in Microsoft SQL Server 2012 RC0. In SQL Server 2008 R2 we would use the command:
sp_changeobjectowner ‘[BadUser].[NameOfTheTable]’, ‘dbo’
But when attempting that on SQL2012 it wouldn’t work. It was claiming that either the object didn’t exist or the command wasn’t valid for that object type.
I’m not sure if that is a bug or if they changed the functionality of that SPROC on purpose.
We were able to find a workaround though by changing the schema information with the following command:
alter schema dbo transfer [BadUser].[NameOfTheTable]
If someone knows why the first SPROC didn’t work and the second had to be used, please let the rest of us know by posting in the comments.
UPDATE: Looks like this is by design:
That’s one of many functions depreciated in 2012 (and future versions).