Hi,

This is really winding me up. How on earth do you type a carriage return
  into a field from the "open table" view in SQL Server Management
Studio? I think I've tried everything - including copying and pasting
something with a carriage return in it. It seems to strip all text
pasted in after the first carriage return. The field is NTEXT, but that
probably doesn't matter.

In SQL 2000 it was very straightforward.

Nick...

Nick Gilbert (nickg@newsgroup.nospam) writes:
The answer is that you start to learn to use INSERT statements to enter
your data. Open Table does not permit you to insert line break.

By the way, SQL 2005 offers a new data type nvarchar(MAX) which just
like ntext permits unlimited amount of text, but that does not have
all the quirks and limitations of ntext. Strongly recommended.

Obviously I know how to use INSERT and UPDATE statements, but sometimes
you just quickly want to change a value or two and having to write an
insert or update query just to do something this simple is a hassle. You
could do this easily in SQL 2000 so I don't see why they've opted to
remove this possibility in SQL 2005. Why not just let CTRL-Enter insert
a CR like you can in most other databases and programs? GRRR.

Thanks for pointing this out... Sounds very useful!

Nick...

Hi Nick,

Thank you for the posting.

Thank you for taking the time to provide feedback on this product. 

We are very interested in your thoughts and opinions for improvements that
we can make to provide the features and functionality you and your
customers would like to see. 

To provide your feedback directly to the product groups:
http://lab.msdn.microsoft.com/productfeedback/default.aspx

If you have any questions or concerns, please feel free to let me know.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Wei Lu [MSFT] (we***@online.microsoft.com) writes:
This link is outdated. The feedback site is now at
http://connect.microsoft.com/feedback/default.aspx?SiteID=68.

Hi Erland,

Thanks for your provide.

The link I provided does not outdated. You could still access the feedback
page by drillthough the page.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Wei Lu [MSFT] (we***@online.microsoft.com) writes:
Yes, the link does take you to the Connect site, since there is a
redirection in place.

Nevertheless, I think Microsoft staff should post the correct links,
so please use the direct link to Connect in the future.

Hi Erland,

Thank you for the suggestion. I would like to use the direct link next
time. Thanks!

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

2005 Fonts and Colors for Management Studio
need tool for managing database object ownership
OSQL Input File Size
Backup and Restore
How to Remove "SQL Server Management Studio" from My Docs?
save query results to formatted text file
SQL Server Management Studio - one file per object
bcp invalid object name
Outlook locked with sql 2005
Management Studio: Backup and Restore Events Report