Home Forums SQL Server 2014 Development - SQL Server 2014 Using hardcoded database names in query when database names are different on development and production server RE: Using hardcoded database names in query when database names are different on development and production server

  • December 26, 2017 at 2:41 pm

    #1973529

    That's going to be a royal pita.

    Why not just stop using different names for dev and prod?  It's easier to mess up the aliasing than it is to just use the same name and use other methods to insure the DEV is only used on dev and PROD/LIVE is only used on prod.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.