Problem With ID Update After Deleting Rows

Hi,



I hope some of you can help me with that



I made an application that insert some data to MS SQL 2005 DB Express Edition. One of columns in my database store text. The content of that field must, beyond the existing text, append the current id to its text string. Practically, it means that if on row nr 15 I store text value "15text", on the next row i will store "16text". I figured out that I can get value of max ID by creating following stored procedure.

USE [tracking_db]

GO

/****** Object: StoredProcedure [dbo].[spMaxId] Script Date: 07/18/2007 09:31:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER PROCEDURE [dbo].[spMaxId]

@maxId integer output

as

SELECT @maxId= MAX(id) FROM FILES_TABLE





Once i get the maxID value i simply concat max id and string like:



string.Concat(max_id.ToString(), file_name);



where "max_id is integer return value from stored procedure and "file_name" is a string to rename like "max_id+file_name"





Two problems occur!!!

Problem nr 1.



Since I use to insert 10 new rows each time, the values from 0-9 are appended to text like "(0-9)text"



Problem nr 2.



If I delete some rows, ID does not get update. It means that after deleting all rows from table, next inserted item gets last existed ID before delting +1. New inserted item should get value 1 since table is empty after deleting all rows from it!!!



Hope some of you has any idea what to do



Muris