Insert or Append?

Hello all,

Number of rows in a table was increased significantly. Is there a way to see
whether data was inserted in to the table, or whether data was appended to
the table?

Thanks in advance,
Do.

--
Message posted via http://www.sqlmonster.comWhat do you understand is the difference between "insert" and "append"?
Do you mean INSERT and BULK INSERT? In any case, there is no built-in
way to know which process INSERTed a row into a table, unless you log
that information yourself, either in the table or in some other way.

Simon|||Do Park via SQLMonster.com (forum@.nospam.SQLMonster.com) writes:
> Number of rows in a table was increased significantly. Is there a way to
> see whether data was inserted in to the table, or whether data was
> appended to the table?

You can't append data to a table, as append implies an order, and tables.
logically, are unordered sets of data.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp