'The default schema does not exist' on deploy of SQL CLR assembly onto SQL Server 2008
Posted
by abatishchev
on Stack Overflow
See other posts from Stack Overflow
or by abatishchev
Published on 2010-03-22T18:42:43Z
Indexed on
2010/03/22
20:41 UTC
Read the original article
Hit count: 489
I'm deploying an example SQL CLR
stored procedure which has a SQL CLR
type as parameter using Visual Studio 2008 and menu Project -> Deploy
.
public partial class StoredProcedures
{
[Microsoft.SqlServer.Server.SqlProcedure]
public static void TakeTariff(TariffInfo tariffInfo) { }
}
public class TariffInfo
{
public SqlDecimal Amount { get; private set; }
}
but getting next strange error:
The default schema does not exist.
How can I fix that?
My user was created this way:
CREATE USER myUser FOR LOGIN myLogin_mod WITH DEFAULT_SCHEMA = mySchema
© Stack Overflow or respective owner