You're not doing anything wrong; that's how the identity property works. For this reason, one should not rely on the identity property always incrementing without gaps. Think of...

quote:

---

quote:

---

Your two "answers" seem to be for a different question from that asked...

quote:

---

I think one ship_location can accept more than one shipper

---

That's what...

Have you read the relevant MS Knowledge Base articles, e.g. How to Monitor SQL Server 2000 Blocking?

--Jonathan

SELECT Table_Schema + '.' + Table_Name

FROM INFORMATION_SCHEMA.COLUMNS

WHERE OBJECTPROPERTY(OBJECT_ID(Table_Name),'IsUserTable') = 1

AND Column_Name = 'YourColumnName'

--Jonathan

If this is SQL Server 2000, I'd use a UDF with a constraint, but if you've got to use a trigger, perhaps something like this:

CREATE TRIGGER...

CAST(LTRIM(STR(@Tax1,9,6-PATINDEX('%[^0]%',REVERSE(@Tax1)))) AS char(16))

--Jonathan

quote:

---

quote:

---

Quick brainteaser for our beginning DBA's: what's the quickest method to strip out...