mardi 3 février 2015

Explicitly acquire EXCLUSIVE LOCK on a SEQUENCE OBJECT


How can we explicitly acquire a exclusive lock on a Sequence object in SQL Server 2012?


I am creating an application and need to lock a sequence object so no other transaction fetch data from it.


Can we achieve this by using get_applock procedure?


Thanks





Aucun commentaire:

Enregistrer un commentaire