Precision And Scale Of SqlDecimal Parameter To Stored Procedure

I am using SQL CLR Integration to create a series of stored procedures.

I am building and deploying from Visual Studio 2005 SP1 and everything is working well except for my stored procedures that have a SqlDecimal typed input argument. By default, the precision and scale of the SqlDecimal is deployed to SqlServer as (18,0).

How can I change this default?

This is an example of my stored procedure definition:



namespace Microsoft.Hurley.DataStore

{


public partial class StoredProcedures

{


[Microsoft.SqlServer.Server.SqlProcedure(Name = DB.PROC.TEST.INSERT)]

public static Int32 insertTest(out SqlInt16 cTestID, SqlInt16 cOrgID, SqlString cName, SqlDecimal cPassPercentage, SqlByte cNumberQuestionsToDisplay, SqlByte cMaxNumberAttempts, SqlBoolean cIsActive)

{

...

return returnValue;

}

}
}
From SQL Server after the procedure is deployed:

[dbo].[insertTest]

@cTestID [smallint] OUTPUT,

@cOrgID [smallint],

@cName [nvarchar](4000),

@cPassPercentage [numeric](18, 0),

@cNumberQuestionsToDisplay [tinyint],

@cMaxNumberAttempts [tinyint],

@cIsActive [bit]



Thanks!