Is there a way of distinguishing a now empty table that
has had exactly one row inserted and subsequently deleted
from a table that has never had a row inserted? We have a table with identity seed set to 101.In both the above cases IDENT_CURRENT('tablename') returns 101. How do I isolate a table that has never had a row inserted?
has had exactly one row inserted and subsequently deleted
from a table that has never had a row inserted? We have a table with identity seed set to 101.In both the above cases IDENT_CURRENT('tablename') returns 101. How do I isolate a table that has never had a row inserted?