I have a below scenario in my development project:
There is a template for creating a database. Users want me to create databases using this template on need basis & none of the previous versions of databases should be dropped. I would like to know the best practice to name these databases every time I make a new copy. And, also the users demand a new user id with default database pointed to the new database so I end up creating a new login/user id whenever i create a new database.
Please suggest me with any best practice for naming the databases & userid's.