The database does not exist. Make sure the name is entered correctly.

Question

Why do I have such an error? If you look at the screenshot, you will see the database. This only happens when I am connected to two databases. It only detects databases from the database engine below, and not allocated.

Is there a way to use my database other than closing the application and opening only one database engine?

Answer 1

Just highlight the database engine you want to use first, then click and this.

Answer 2

You should be able to see which server you are currently connected to in the lower right corner of the window. Most likely, it is connected to another server. You can select the desired server, and then click "New Request", and then simply copy and paste the code.

Answer 3

You can also redirect the server that your query window points to in SSMS, without starting a new one and copying / pasting:

Query menu → Connection → Change connection