Running the script to setup object locking (Redgate Source Control)

jornvangojornvango Posts: 16 New member
in SQL Source Control
Our DBA has been executing the script to allow for Redgate Source Control to lock a database object ('check out').  However, the script has been running for over an hour and seems to be stuck on these 2 commands:

ALTER DATABASE RedGate SET ALLOW_SNAPSHOT_ISOLATION ON

ALTER DATABASE RedGate SET READ_COMMITTED_SNAPSHOT ON 

Should we wait longer until this finishes, or is there something else we need to look at?

(MS SQL Server 2016)


· Share on Twitter
Sign In or Register to comment.