Database

GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [test\me].[GIStoCRW]

AS
BEGIN

	SET NOCOUNT ON;

EXEC sp_addlinkedserver 
   @server = 'CRW',
   @provider_name = 'SQLNCLI',
   @datasrrc = 'TheServerName',
   @catalog = 'TheTablename'

EXEC sp_addlinkedsrvlogin CRW, FALSE, 'My Login’, NULL

update CRW.GEO_UDF set WATERDISTRICT = 'TEST' where SITE_APN = '123'

END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [domain\me].[TestUpdate]

AS
BEGIN

update gis.crw_gis_data set block = 'test' where id = '123'

END

GO

Sharma Dinesh Kumar wrote:

i want encrypt data inside the table of database .