'The default schema does not exist' on deploy of SQL CLR assembly onto SQL Server 2008
- by abatishchev
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
