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,
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.
