SQL source control disabled on one database because its selected in another SSMS window

wilkoski

Hi,

I'm getting the error "SQL Source Control is disabled for this database because its selected in another SSMS window".

This is happening only one one database, all others databases on the same SQL server are fine.  I've only got a single instance of SSMS running, there are no other users logged on.

I'm on v7.2.35.13078

Any suggestions as its blocking me from being able to update this one single DB?

Thanks

Steve

Kurt_M

Hi @wilkoski,

Unfortunately, this issue is normally related to there being another instance using this database. Can you double check the list of processes to make sure there isn't one hanging in the background?

Also, what happens after you close and re-open the instance you've got open, does that resolve the issue?

Do you potentially have any other IDE's (Visual Studio, VScode etc.) running that could be using this database?

wilkoski

Hi Kurt,

There were definitely no other processes running, nor other IDE's etc.

However a reboot has resolved the problem.

Steve