Posted by AlterEgo on 02/09/07 18:18

Dmitri,

SQL Server doesn't just ignore transactions. If the statements are showing
up in SQL Server Profiler, then SQL is executing or attempting to execute
them. There may be other reasons why you are not getting the expected
results. Try these steps:

1. Backup the database.
2. Run a trace. Remove the Existing Connection and Audit events before
starting the trace. They are not necessary for this exercise and create
additional noise. You may want to set up a filter that captures only the
application being tested.
3. Save the trace as a SQL Script.
4. Restore the database.
5. Open the SQL Script and run it.
6. See if there are any errors or warnings that are not being trapped by the
VB.NET application.

-- Bill

"Dmitri" <nienna.gaia@gmail.com> wrote in message
news:1171036327.517795.9440@s48g2000cws.googlegroups.com...
> Hello!
>
> I have a developer that is playing around with some SQL statements
> using VB.NET. He has a test table in a SQL 2000 database, and he has
> about 2000 generated INSERT statements.
>
> When the 2000 INSERT statements are run in SQL query analyzer, all
> 2000 rows are added to the table. When he tries to send the 2000
> statements to SQL Server through his app., a random number of
> statements do not get executed. But, SQL Profiler shows that each of
> the 2000 statements are getting sent to the server.
>
> I suggested that he add a "GO" statement at the end of the INSERT
> block, but the statement fails when that is sent to the server.
>
> I know that this is not the ideal manner to insert bulk data to the
> system, but now we are all just curious as to why SQL server doesn't
> execute each individual INSERT.
>
> Any thoughts?
>

[Back to original message]