naming databases when transitioning environments

There is plenty of debate on naming standards that I’ve read, none of which address a question I have on the database name itself.

I know a number of sites that like to incorporate the environment (eg. DEV, TEST, PROD) into the database name so ‘mydb’ becomes ‘mydb_DEV’, etc.

A number of developers but mainly DBAs seem to like this.

In many issues there are pros & cons, however, I cannot see any merit in this. It is a significant hassle where cross-db references are used in stored procs and in maintenance scripting where database names cannot be aliased (easily anyway – I use SQLServer)

I was interested in feedback on this.

thanks