Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Check which table is in use

Author  Topic 

nshankar
Starting Member

9 Posts

Posted - 2009-07-23 : 01:52:03
Hi All,

How do i check whether the table is in use. i need to check if the table is in use, i need to restrict the other user not allowing to update/delete.

is there a way to which returns a value so that based upon the value i can disable update in the front end

Thanks
Shankar.N

asgast
Posting Yak Master

149 Posts

Posted - 2009-07-23 : 06:22:13
Look BOL for transactions and table locks, or explain what you are trying to accomplish.
Go to Top of Page
   

- Advertisement -