Contents tagged with Sql Server

  • Database alias in Microsoft SQL Server

    by Bohumír Kubík

    We have a scenario where more databases with the same schema are running on one SQL server instance (imagine the same application deployed for several customers with dedicated databases). We also needed to specify database name in stored procedures (in fact, we don’t have only one database per customer, but a pair of databases so that we have to specify the other database name). The problem is that when you compare database schema among all of them, which is what you’ll be doing … more