Can you maybe give us an example of your input data and desired output? Table structures too if possible.

LOL. I know the feeling.

Good luck.

Oh, that's easy.

SELECT SomeFields FROM SomeTable

WHERE RowID BETWEEN @RowID-2 and @RowID +2

It'll return up to 5 rows. If you don't want the equality condition,...

Sorry, I didn't quite get what you want.

RowID?

I haven't seen that error since I did web dev some years back, but then it was because of the cursortype and lock type. There are some combinations that aren't...

Because drop table is a logged operation and you are reqesting a rollback ie undo everything up to where the transaction began.

By the way, your code shouldn't even run. You...

Can you post the code of the stored procedures and the table structure please

Yes, it's one of the new SQL 2005 DM views. Since this is the SQL 2005 forum, I did the 2005 solution.

You can do the same thing with sysprocesses in...

Again, 5 users (5 different user names) or 5 connections? Is a single user allowed to make multiple connections to the database, and if so, do you count each of them,...

How many users, or how many connections?

For number of connections,

SELECT

count(*) FROM sys.dm_exec_connections