I am using ado.net transaction with isolation level set to read uncomitted
in a program which runs a batch process. However, this locks up the tables,
and does not allow other classes to fetch data from these tables which are
within the transaction.Any guess where i could be going ...

Lately the size of our transaction logs have increased substantially and I
just need to know it's not something wrong with my knowledge of ado and
programming.  I've never had formal tranning on ADO.
Is the following is the ideal way to execute an Update?

Why is this an inaccessable property.  As soon as I do an update to the
table, it is storing the @@Identity value - that I need.  Why has it
been made unavailable???
Sam

I  need to read the data in an Excel spreadsheet and store it in a sql
server table.  I want to do this using ado.net rather than a DTS package so
that I can do some error checking and make it user friendly.
How do I create a data reader or data table when my source is an excel

Can I use Access 2002 to back up my MSDE database? If so, how? I looked at
it today and couldn't find anything obvious on how to do it.
Thank you..

    Just wondering if someone could help me. I have a CSV file of around
100,000 entries. The application I am building will accept a CSV upload
from the user and insert it into the database.
    I noticed, using the normal insert into a Data Table, then out into the

Is it possible to read the remarks for fields in Access database?
I want to display them as tool tip
Explanation:
Upon editing table in access (design view) u insert the table characaristics

I have not been able to get a PLSQL stored FUNCTION to return a ref
cursor. (Stored Procedures work fine.)
I get a ORA-06550 return codes, and other similar messages that
indicate that the C# OracleParameter should be of Direction type =

I have several pieces of information (about 20 rows) that I would like to
put in a DataSet to make them easier to use in my application. Because it is
very little data, I would prefer not to make a database for such little data
that will very rarely be changed. However, ...

got a burning question here. in a data access layer, a DataAdapter.fill()
method is used to execute an update statement without any select in a store
procedure.
what happen is it works without any problem in a few level of testing

Has anyone come across the scenario where you create a data adapter in
VS.NET 2003 using the IDE along with its related data connector on
computer A.  When you copy the project to computer B and try to
configure the data adapter the data connection disappears and you have

According to an MSKB article
(http://support.microsoft.com/default.aspx?scid=kb;en-us;314429), there is a
bug in PerfMon whereby certain counters are not reset correctly.
I need to stress test an ASP.NET solution with specific respect to

can anyone tell me why the following will not work or how to fix it.  This
works fine for executing sprocs with no parms but fails (always returns -1)
when executing with parms.
from webform:

I have the following query I run using SQL:
Select Distinct col1 as D1, col2 as D2, count(col3) as CountOf
from MyTable
group by col1, col2

I have a database which stores the Accounts and products information. Account is always updated with products values. For existing products, I have to use UPDATE SQL command. If new products are added into Products table, the new Product rows need to be inserted into Accounts ...