>>>>

>>>>
>>>>SET ANSI_NULLS ON
>>>>GO
>>>>SET QUOTED_IDENTIFIER ON
>>>>GO
>>>>
>>>>ALTER PROCEDURE [dbo].[GetNextNumber] 
>>>>	@NextNumber varchar(10) Output
>>>>AS
>>>>BEGIN
>>>>	SET NOCOUNT ON;
>>>>
>>>>   Set @NextNumber = '0000001045'
>>>>END
>>>>
>>>>

>>>>
>>>>What could be missing from the stored procedure?
>>>
>>>You declared parameter as varchar(10), so it's going to be truncated. Declare it as varchar(50) at least.
>>
>>I am confused, the value I set was only 10 chars long. What would get truncated?
>
>You're right, I miscounted. Did you also pass 10 0s ?

Yes, as a string