I would like to clown one of the databases I have, give it another name and use for to connect to another application.
What I am saying is, let’s say an AdventureWorks database, I want to clown it re-attach and call it Transactions for instance. So my SSMS, would have both. How would I achieve that?
I am working on SQL server Developer edition.