More then one Auto Increment Field in SQL Server

I have a table, in which my PK is a an AutoIncrement Number (Identity). Now I need another field which needs to be 10 Digit & Unique, is there any way i could have 2 auto increment field? I want to avoid generating the number from front end and the passing it.

I would prefere if this could be managed in Back End. Could i use trigger for that sort of thing, or any other ideas?

Thank you.

From SQL Server Books On-Line:

Quote:

---

A table can have only one column defined with the IDENTITY property, and that column must be defined using the decimal, int, numeric, smallint, bigint, or tinyint data type.

---

Instead of identity columns, I have a numeric field whose value gets populated by the Stored Procedure that executes the INSERT statement. I just get the Max() column value and add 1 to it:

Code:

---

Create Procedure ins_myTable @Field1 varchar(50),
                            @Field2 varchar(50),
                            @Field3 varchar(50)
AS

Declare @IDCol int

Select @IDCol = Max(id_col) + 1 From myTable

If @IDCol Is Null Set @IDCol = 1

Insert Into myTable (id_col, field1, field2, field3)
Values (@IDCol, @Field1, @Field2, @Field3)

---

You might could try something like that.