I'm not very familiar with SQL Server, more familiar with MySQL.
I'm used to seeing everything in code, whereas SQL Server, some things are done with buttons. In MySQL, I'd execute
USE testing_database and then I'd know my subsequent queries would execute against that database.
In SQL Server Management Studio, I see that my "Testing Database" is selected in the dropdown select. Does that mean that the queries in the script will execute ONLY against that database?
The script does not include any references to database names. It uses
sp_msdependencies to populate a list of Views and then acts on that list. Will
sp_msdependencies execute only against the current database?
There are several other databases besides the testing database that I do not want to touch with this test.