Skip to content
«
»
 

Local Linked Server

Posted by 
on  June 18 2009

You are currently browsing comments. If you would like to return to the full story, you can read the full entry here: “Local Linked Server”.

Filed under SQL Server Tagged ,
Comment (RSS)  |  Permalink

3 Comments

  1. kiran says:
    November 28, 2011 at 12:39 pm

    i just started my sql dba job am new one in this field.
    1-I hv configuere Linked server,bt i dont know how it is used?
    I hv added Link server throgh SSMS.As shown above.
    How i can utilised it.

    2-I hv db in datacentre room,so that i hv give 2 cilent conncetion to my near room.aleardy there r 2 m/c’s with OS Win7.
    My db server installed on SQl server 2008 stnd R2 edition.
    wat is requirement for cilent M/c’s.pls suggest me.

    Reply to this comment
  2. Sree says:
    August 17, 2010 at 11:54 pm

    Thank you it helped me.

    Reply to this comment
  3. Insert Results of Stored Procedure Into Table says:
    June 18, 2009 at 10:38 pm

    [...] The way to dynamically create a table based on the stored procedure’s output would be to use OPENQUERY. There is an additional setup using this. Ad Hoc Distributed queries must be turned on, and you have to create a linked server connection to your own local server. Click here for instructions to create a local linked server [...]

    Reply to this comment

post a comment OR Post Your Question on our ASK! Community!

«
»