How to resolve Sql Server Error Message 117 - Too many prefixes for object name?

I am transferring a database from one hosting provider to another. The current provider uses the domain name as part of the user name. The domain name is a .co.nz domain. So some objects in the database have a fully qualified name of user@company.co.nz.tablename.

Im trying to alter the schema of these objects to put them into a dbo schema using:

ALTER SCHEMA dbo TRANSFER user@company.co.nz.tablename

But i get Error Message 117:

The object name 'user@company.co.nz.tblExceptionLog' contains more than the maximum number of prefixes. The maximum is 1.

In another database I get the same error message but the maximum number is 2. So obviously the maximum number of prefixes can be set... somewhere. How do I increase the maximum number of prefixes so I can transfer securables out of the user@company.co.nz and into the dbo schema?

Answers


It's interpreting your dots as different prefixes, while in fact, I'm guessing they're just part of your database name...? In that case, increasing the amount of prefixes allowed is not what you want, but rather something like this:

ALTER SCHEMA dbo TRANSFER [user@company.co.nz].tablename

Need Your Help

can you not compress CSS but work on it later?

css compression minify

I've even looked at CSS Crush, Minify, SmartOptimizer, CSSTidy and a slew of other PHP CSS compressors. But they all have one major flaw.

Saving addressbookUI data to an array

iphone nsarray abpeoplepickerview

I'm trying to save the kABFirstNamePropert, kABLastNameProperty and kABAddressProperty all saved into an array for recall later, I'm just not getting it, can anyone lend me a hand or point me in the

About UNIX Resources Network

Original, collect and organize Developers related documents, information and materials, contains jQuery, Html, CSS, MySQL, .NET, ASP.NET, SQL, objective-c, iPhone, Ruby on Rails, C, SQL Server, Ruby, Arrays, Regex, ASP.NET MVC, WPF, XML, Ajax, DataBase, and so on.