I have a table TableA in database A1 on SQL server A.
I have a table TableB in database B2 on SQL server B.
I would like to have a stored procedure on server B that uses an
INSERT INTO A.A1.DBO.TABLEA
SELECT *
FROM B2
to copy data from one server to the other.
Server A may be configured to allow NT access only, or it could be
configured for SQL security and NT.
I am logged into server B using SQL authentication.
What are the relevant security concerns? Can it be done ensuring
security.
I know I need server A entered as a linked server on server B.
It seems to be a problem when SQL authentication on server A is turned
off.
I have a table TableB in database B2 on SQL server B.
I would like to have a stored procedure on server B that uses an
INSERT INTO A.A1.DBO.TABLEA
SELECT *
FROM B2
to copy data from one server to the other.
Server A may be configured to allow NT access only, or it could be
configured for SQL security and NT.
I am logged into server B using SQL authentication.
What are the relevant security concerns? Can it be done ensuring
security.
I know I need server A entered as a linked server on server B.
It seems to be a problem when SQL authentication on server A is turned
off.