how to Add linked server?

Results 1 to 1 of 1
  1. #1
    Newbie hero1c is offline
    MemberRank
    Jul 2010 Join Date
    6Posts

    how to Add linked server?

    please help .

    ---------- Post added at 12:54 PM ---------- Previous post was at 12:23 PM ----------

    can you post pictures on how to do this and how to insert this codes into it
    Spoiler:
    exec sys.sp_addlinkedserver 'RANKING', '', 'SQLNCLI', 'SQL SERVER INSTANZNAME', null, null, 'RANKING_DBF'

    exec sys.sp_serveroption @server='RANKING', @optname='rpc', @optvalue='true'
    exec sys.sp_serveroption @server='RANKING', @optname='rpc out', @optvalue='true'




Advertisement