SQL Server Performance

Acess error

Discussion in 'SQL Server 2008 General DBA Questions' started by Rabani, Apr 19, 2009.

  1. Rabani New Member

    Hi ,
    Ineed to move data from my test envirnoment in a MS SQL Server 2000database to a staging envirnoment, also a MS SQL Server 2000 database.I created a linked server and tried to use import, export, and insertcommand, but both failed. I get an Access Denied error.

    Does anyone know why I would receive this message, and how I can fix it?
    Thanks,
  2. satya Moderator

    If you need to import/export data and connection between source & destination server is constant then best to use DTS wizard, linked server is not that efficient to manage the data between the servers unless you have set of data to update from here to there.
  3. dhamu294 New Member

    Use DTs for this kind of activities. wizard will lead you. it will be more easy.

Share This Page