How to format auto id number to 0000001 in Sql Server?

declare @num int
declare @fixed_size int

set @fixed_size = 10
set @num = 40

SELECT @num as [orig], RIGHT(REPLICATE('0',@fixed_size) + CAST(@num AS varchar(10)),@fixed_size) As [modif]