There is no way to eliminate logging. SQL Server writes changes to the Log and then to the database from the log. Changing the recovery mode to simple will...

You could do it a couple of ways. You could concatenate all the columns in the table and then use LIKE. You could use "OR". If you...

David Griffiths (7/11/2008)

---

With the greatest respect - I disagree.

Admittedly I am using SQL Server 2000 so perhaps this is something that has since been resolved. But I work on a...

Okay, so what is the SQL that is being run in the VB app when it times out?? How long does it take to run in SSMS/QA? What...

You can also set up a server side trace that you can then look at to determine what is going on. My guess is you are sleeping when the...

What else is happening on the server when the job is running? Are there other jobs running that access the same resources? Are there backups running?

Without...

bdba (7/11/2008)

---

The code is posted just for an example to show how I am trying to capture the @@rowcount to print message whenever 1000 rows updated. There is a lot...

What is the app written in which is returning the error? Have you looked into the code that they are running when this happens? Sounds like there is...

I tried creating an excel file with some random dates and could not duplicate what you are seeing. Can you attach a subset of data in Excel?

Are you using...

It looks like you actually named the parameter in the stored procedure @tour instead of @TourID. Either change the stored procedure to use @TourID or change the .NET code...

Could you post some sample data?

Congratulations Gail. I was pleased to see you recognized as well. I always take the time to read any forum threads where I see your name.

Congratulations. You both certainly have been contributors to the SQL Server Community.

READ COMMITTED is the default Isolation Level in SQL Server. This is why a select will not finish until any exclusive locks are released.

For example in my example, if...

Gabor,

I actually misread your original post. In order to insure that the second user sees the data prior to the delete while the delete is on-going you need to...