>>>

>>>
>>>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 ?