how to find out a locak level set for a table. Strange problem

[ramyareddy]

Hi All,

i am using mssql 2005 and i am facing a strange problem.

i have two databases A , B.When i try to insert one row in A from my application it is inserting the row but after that it is giving page not found exception when i try to retrieve the data to display form the same table.
When i do the same operation on B from my applciation it is not throwing any error.

1)Is it to do with the lock levels set on the data base.
can you give me query to find out lock level set on the table and query to set the lock levels.
2) How to compare the two data bases to find out the difference in the settings..
second problem:

when i access the data base from my application
a session opened against a database . The connection was made via the jdbc driver so I believe that the session was precipitated by the front-end application.

the session initiated a page lock against a table with the intention of doing something to it (insert/update/delete). For some reason, the session remained inactive for the past 5 days but maintained the page lock on the table. The result of this was that any activity requiring access to the records contained within that page were blocked, pending the release of the lock.

Is there any way to prevent this by imposing the lock level setting form my front end application. I am using spring MVC frame work with Spring jbdc to connect to my data base.

Please help me , its very urgent........


Thanks for any help

Ramya