Ensuring unique numbers from a sql server database

I have an application that uses incident numbers (amongst other types of numbers).These numbers are stored in a table called \"Number_Setup\", which contains the current value of the counter.