Home Forums SQL Server 7,2000 T-SQL Dynamically change database depending on the server? RE: Dynamically change database depending on the server?

  • We've tried several options, but it really seems as if a dynamic 'use' statement can't be run inside SSMS2012.

    We are considering the use of synonyms and linked servers and are planning to implement this. It will mean having to change all 300 feeds.

    I will post here when we reach a solution.