Thanks, another option i use often is to set the DB to Single user mode and rolling back any uncommitted transaction and when done enable it for connection.

...