[thelist] SQL not performing all inserts

[Ken Schaefer]

: -----Original Message-----
: From: thelist-bounces at lists.evolt.org [mailto:thelist-
: bounces at lists.evolt.org] On Behalf Of Robert Vreeland
: Subject: RE: [thelist] SQL not performing all inserts
: 
: The application outputs success / failure to a message window along
: with any errors.
: Is it possible the SQL server is suppressing the errors? Where would I
: look for that?

Where you would look would depend on what you are using to interface with SQL
Server. SQLClient? ADO/OLEDB? DAO? DTS?

ADO Connection has an errors collection - that would be the first place I
would look if you are using ADO

As mentioned before, SQL Server has a Profiler tool that you can run against
the database server to see exactly what's going on.

Cheers
Ken