Running the script to setup object locking (Redgate 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)


Sign In or Register to comment.