Alright, AJ Ahrens, before you criticize the question, maybe you should find out if there a logical reason behind it.

The reason is because we do not have complete control of the system....

There is a problem doing this. The tables do exist, but the columns I am referencing do not currently exist in the database I want to create the procedure in....

alzdba, Vladan, Razvan, SmithDM, thanks for the help. With your explanations I do understand what is going on, I just never new the joining order was something you had to...

alzdba, your suggested query works! But, why? I don't understand. What does moving the "On edc.DSTDate_dt = hcd.HOLDATE" to the bottom do to they query? What are the rules for...

I also just took a look at it and found it to be of use.

Thanks

Yes, I have used them, just looking for an easier way. It is hard to pick a connection that is taking up quite a few resources when you have a...

I guess I was mainly interested why it was getting bigger, as in what gets put into a transaction log. I havn't found much documentation that really tells what gets...

The user does not have backup permission on our production database. He just uses a development database to do his work and we are not concerned if he breaks anything...

Yes you have misunderstood. Sorry I was not clear. I want an disconnected recordset that I can keep in my client application and update as the user makes changes and...

Alright, I think that is what I will do.

Do you agree though that I will have better performance if I can programmatically keep my connection limit below the 255 default...

We are running SQL Server 2000.

I do not see "The working thread limit of 255 has been reached" in SQL Server error log.

So, what you are saying is my performance...

Do you think if I have around 350 consistently open connections based off of the following query, that bumping up the "max worker threads" past 350 will help?

SELECT cntr_value 'User...

One more question. Does the number of records in master..sysprocesses table reflect the number of open connections. I am assuming this is true but have no way to tell for...

Thank you Allen, this is the kind of information I was looking for. This makes sense if we have 350 open connections at any give time and only 255 max...

OK, great, we agree that is going to only suck up roughly 8MB.

Now, including myself, everyone says that connections should be closed when not being used. Is everyone saying...