Yes, that should be the right way to do.

Thanks gil.milbauer...

CREATE PROCEDURE dbo.sp_NewSequentialId

(@Id AS UNIQUEIDENTIFIER OUTPUT)

AS

BEGIN

SET NOCOUNT ON;

DECLARE @NewSequentialId AS TABLE (Id UNIQUEIDENTIFIER DEFAULT(NEWSEQUENTIALID()))

INSERT INTO @NewSequentialId DEFAULT VALUES;

SELECT @Id = Id

FROM @NewSequentialId;

END

GO