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

From http://www.developmentnow.com/g/95_2...-sqlserver.htm

Posted via DevelopmentNow.com Groups
http://www.developmentnow.com

Manoj saini (tomksaini@gmail.com) writes:
> 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

On Fri, 08 Aug 2008 05:16:55 GMT, Manoj saini<tomksaini@gmail.com>
wrote:

>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.

Then it is a good thing you are using Microsoft SQL Server, since
running BACKUP does not lock the database.

>But to hit the DB every min is not good solution.

It would certainly be crude, and painful for the user, but it would
not matter to the database.

Roy Harvey
Beacon Falls, CT