They are shared locks as indicated when i run sp_lock.

Thanks

Thanks. My problem is as follow:

I have a query in Access which I am moving to SQL server as part of upsizing. The query is paramerized and its resultset is...

This looks a lot more complicated than I thought. As you rightly said, there are a lot of child tables having the EmpID as FK. May be I can create...

Thanks for your help. I will give it a try.

I am talking of data for now. I have inherited 3 SQL servers with different collation settings. The 3 servers need to have their data synchronized on a daily basis....

Thanks. That is it.