I have a question!
I have a database with a invoice table for storing invoice data. In this table i use the InvoiceID as my invoice number.
My problem is that if a user makes a mistake and the invoice is deleted in order to create a new one the sql server 2005 picks a new id number and leaves a "gap" between the id numbers.
The invoice id is my identity columne and the data type is "int". How do I set the server to fill evetually gaps before moving forward in the id numbers..
I really hope somebody can help me...