SQL Server Performance

can we link the linked server to a database instead of at server level

Discussion in 'SQL Server 2005 General DBA Questions' started by bobbasatish, Feb 6, 2008.

  1. bobbasatish New Member

    My question is whether it is possible to link a server to a database through linked server.
    2nd question
    Currently we have all our databases in one server. My DBA is bringing a new server and moving some of the Databases to the new one. In this case I got to access the objects in my new server from the ETL code in my old server. I think this would be a tedious tasks to rename all the ETL's and SP's to change from dbname.objectname to servername.dbname.objectname...Is there any way to create an alias to the linked server so that we need not change anything.
    bobbasatish, Feb 6, 2008
    #2

  2. jagblue New Member

    Hi
    Use SYNONYM in sql 2005
    look for more help in books on line for this
    Thnaks
    jagblue, Feb 6, 2008
    #3

  3. vbkenya New Member

    Think of a linked server as a definition for a data connection. By linking directly to a database, you would be missing one important component of a connection - the physical location of the database (generally called the data source). This would make it impossible to know where the physical database is residing.No. You cannot link a server to a database.
    vbkenya, Feb 6, 2008
    #4

  4. satya Moderator

    Welcome to the forum!
    As referred a synonym is an alternative name for a schema-scoped object. Client applications can use a single-part name to reference a base object by using a synonym instead of using a two-part, three-part, or four-part name to reference the base object.
    For linked server:
    In SQL Server Management Studio open Linked Servers and then 'New Linked Server'.
    • Inside of appeared wizard – Select the General tab.
    • Specify alias name in "Linked server" field.
    • Select SQL Native Client as provider.
    • Add sql_server in "Product Name" field (that's the magic).
    • In "Data Source" – specify name of the host to be used as linked server.
    satya, Feb 7, 2008
    #5

Share This Page