Copy/Paste text into a field

Hot Topic

Remote Connection to file-based Express DB
ODBC password not saved in configuration file
Cannot Enable Remote Connections for AS 2005 on clustered instance
Internet integration
4 GB Size limitation
How To Avoid Table Scan
sp_helplogins
Reporting Services datasource corruption?
SQL Server 2005 Backup Jobs Not Working; Login Failure for 'NT AUTHORITY\SYSTEM'
How to write Lookup error to table and then fail?

SQL Server

Merge replication fails
Set number of records per page globally without using ceiling
Is Ad hoc reporting compatible with Web Applications
Review SQL Server 2000 and 2005 Transaction Logs
SQL Server 2005 - June CTP Developer edition
Failed to generate a user instance of SQL Server...
How do I update multiple base table view?
SQL Server 2000 processor and memory usage tuning
Cannot access properties of index in an SMO index collection.
Importing from a Flat File

Copy/Paste text into a field

I've encountered a strange problem with the Microsoft SQL Server Management Studio.

When I manually edit a record in a table and want to insert text with more lines, only the first line is copied into the field.

The field type I use is nvarchar(max) but it doesn't really matter what type it is.

The problem only exists in the Management studio. When I perform the same task in the "old" Entreprise Manager it works fine.

Am I doing something wrong or does anybody have a key to whats wrong

Thanks!

Ken

Answer this question

Copy/Paste text into a field

  • jjbutler88

    I don't think you are doing anything wrong. I suspect the edit control in the grid just doesn't support multi-line text.

    Please report this issue here: http://lab.msdn.microsoft.com/productfeedback/Default.aspx

    We use defect reports and feature requests filed at the feedback center to make decisions about future versions and service packs of SQL Server.

    As a work around, you could write a T-SQL update statement to make the change you want. That's how the grid control updates the table behind the scenes.

    Thanks,
    Steve



  • KimMPS

    It's been some time since this was originally posted; I wonder if there's been any action taken on this
    I'm also having a similar problem. I often copy/paste text between database tables (usually a development table and later a production table).
    This works fine in Enterprise Manager, but Management Stuido(2005), cells that contain multi-lines are not copied (it seems to be "blowing up" on the crlf; it dosen't seem to be an issue with the length of the text copied).

    Its possible that there is a setting somewhere to change the behavior of the Results grid to allow this, but thus far I haven't found anything.
    I followed the link provided above, but eventually decided it would be easier to write my own interface than to follow all the trails now necessary submit feedback. :)
    At least I can complain here. :)





  • Dave Gelowitz

    I just did a quick search on Microsoft Connect for any bug that was reported by customers, but did not find anything.

    https://connect.microsoft.com/SQLServer/feedback/SearchResults.aspx SearchQuery=copy+paste

    Could you this suggestion on http://connect.microsoft.com/SQLServer/

    Thanks,

    Paul A. Mestemaker II
    Program Manager
    Microsoft SQL Server Manageability
    http://blogs.msdn.com/sqlrem/



  • Copy/Paste text into a field
Answer this question