Stored Procedure

• Anukampa Bali

  Grasshopper

  Points: 11

  More actions

  September 29, 2005 at 5:44 am

  #66907

  I need a help,

  I need to write a stored procedure on our database server (on www), which should update table on our local database server

  I tried

  sp_addlinkedserver

  but is not working

  I just want to know

  Can we define connectionstring within a stored procedure?

  And if yes then how?

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  September 29, 2005 at 6:32 am

  #593992

  Can yu link from the local server to the www server? That way you could put the sp on the local server and execute it from the remote.

• Karl Klingler

  SSCertifiable

  Points: 5869

  More actions

  September 30, 2005 at 4:11 am

  #594281

  Hi,

  you can define a view like:

  CREATE VIEW dbo._v_Item

  AS

  SELECT *

  FROM OPENROWSET('MSDASQL',

  'DRIVER={SQL Server};SERVER=test;UID=xx;PWD=yyyy;',

  'select No_, Description + '', '' + [Description 2] COLLATE SQL_Latin1_General_Cp1_CI_AS as Description, [Item Category Code] COLLATE SQL_Latin1_General_Cp1_CI_AS as [Item Category Code], [Product Group Code] COLLATE SQL_Latin1_General_Cp1_CI_AS as [Product Group Code] , [Product Group Code 2] COLLATE SQL_Latin1_General_Cp1_CI_AS as [Product Group Code 2] from sitesql.dbo.[VSA Gruppe$Item]')

  regards

  karl

  Best regards
  karl