I've just discovered, that
master database contains duplicates of some other databases' tables and stored procedures.
For example, I have a database
SomeDB with table
justTable in it. For some reason, a copy of this table is in
master as well, but with no data.
How is it possible? I'm certain that when I was creating those tables and procedures I was using corresponding databases and not
master. They are all present in those databases (as they should be), just with a copy in
master as well.
I use Microsoft SQL Server Management Studio 2014 with Redgate additions (source control and stuff).