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