'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

Related posts about .NET

Related posts about sql-server