Manoj saini (tomksaini@gmail.com) writes:
Quote:
I need to give one functionality in my application as applicationl lock.
If my databsae is get lock at the time of backup, i need to give a
message to user that daatbse has been locked and ask him to log out.
This application is in Dot net2005. Before db lock , i set one parameter
in table and read this table every min with timer. if parameter is set
then i give message to user.
But to hit the DB every min is not good solution.
Pls help he, how i can avoid hit on dataabse
|
Why would the user have to log out when you do a backup in the first place?
--
Erland Sommarskog, SQL Server MVP,
esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx 
