89431

Microsoft SQL Server copy paste results to excel not working

Question:

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?

Answer1:

Use Task Manager to 'End task' on rdpclip.exe on the remote machine.

Then restart it using a Command Prompt by typing rdpclip

<a href="https://i.stack.imgur.com/VryWo.png" rel="nofollow"><img alt="enter image description here" class="b-lazy" data-src="https://i.stack.imgur.com/VryWo.png" data-original="https://i.stack.imgur.com/VryWo.png" src="https://etrip.eimg.top/images/2019/05/07/timg.gif" /></a>

Recommend

  • SQL Azure SPLIT AT Backend Process and Resource Throttling
  • SQL Count. How can I count how many distinct values are in a table when an other two columns are mat
  • Does Julia have something equivalent to Ans (Matlab) or Last.value (R)
  • cannot be assigned to — it is read only - C#
  • limited threads in soapUI free version
  • How to start server for Selenium grid Java Maven setup
  • Allocating a 2D contiguous array within a function
  • Can my app be notified when another application starts/stops playing audio?
  • Creating UDF with VSTO in Excel
  • Emacs lua-mode issue: (void-function interactively-called-p)
  • Send emails through VB6 if no email client
  • Want to understand iframe breakout code
  • VBA Dir function not working on Excel 2010
  • Outlook to Excel hyperlink issue
  • Dynamically load css stylesheet and wait for it to load
  • C# Excel interop - how to test if interop object is still working and performing a task?
  • powershell Get-Counter -ComputerName parameter on Windows 7
  • Most efficient way to move table rows from one table to another
  • Xamarin MonoAndroid Azure mobile service InsertAsync
  • Rest Services conventions
  • Private IP address in reserved subnet range
  • How To Customize ASP.NET Chart Databound To SqlDataSource
  • Dynamically switching connect in Modelica
  • How to assign byte[] as a pointer in C#
  • std::remove_copy_if_ valgrind bytes in block are possibly lost in loss record
  • nonblocking BIO_do_connect blocked when there is no internet connected
  • Redux Form - Not able to type anything in input
  • Run multiple queries from 1 SQL file showing result in multiple tables
  • Is playing sound in Javascript performance heavy?
  • Get history of file changes from TFS to implement custom “blame”-behaviour of exceptions
  • Xcode 4 NSLog Macro link in Xcode 3
  • Functions in global context
  • SignalR .NET Client Invoke throws an exception
  • Insert into database using onclick function
  • Azure Cloud Service Web Role web pages do not load
  • Knitr HTML Loop - Some HTML output, some R output
  • Can a Chrome extension content script make an jQuery AJAX request for an html file that is itself a
  • XCode can't find symbols for a specific iOS library/framework project
  • coudnt use logback because of log4j
  • jQuery Masonry / Isotope and fluid images: Momentary overlap on window resize