Microsoft SQL Server复制粘贴结果到Excel无法正常工作
问题描述:
我们有一个到Microsoft SQL Server studio的远程连接,我们可以分配4个远程连接.现在,在其中两台服务器上,它使我们能够将结果(网格)复制并粘贴到excel.但是,在其他2台服务器上,它根本不允许我们复制/粘贴.
We have a remote connect to Microsoft SQL Server studio, there are 4 remote connections we could get assigned. Now on 2 of these servers, it allows us to copy and paste the results(grid) to excel. However, on the other 2 servers, it won't allow us to copy/paste at all.
数据库中是否存在阻止我们访问的权限,或者它是否阻止了远程连接?
Is there permissions within the database that would stop us or is it down to the remote connection?
答
使用任务管理器在远程计算机上的rdpclip.exe上结束任务".
Use Task Manager to 'End task' on rdpclip.exe on the remote machine.
然后通过键入 rdpclip