>Hello,
>
>I would like to insert data from my SQL server called AL1
>to the network SQL Server called NET1.
>
>How do I create a linked server to accomplish this task?
>
>Thanks for your help.
>
>Al

Hi,
You can use Enterpise Manager GUI or from Query Analyser call

sp_addlinkedserver [ @server = ] 'server' 
    [ , [ @srvproduct = ] 'product_name' ] 
    [ , [ @provider = ] 'provider_name' ] 
    [ , [ @datasrc = ] 'data_source' ] 
    [ , [ @location = ] 'location' ] 
    [ , [ @provstr = ] 'provider_string' ] 
    [ , [ @catalog = ] 'catalog' ] 

stored procedure