Hello there. I have a SQL Server on my machine. I successfully link to a corporate database (BF-SQL3) using the sp_addlinkedsvr script and am able to see all tables associated with that server, as I am supposed to be. However, we are trying to migrate my SQL Server Database to another corporate wide server (BF-SQL1). For some reason I cannot link the two!!!
-What MS SQL permissions do I need in order to allow this to happen?