Editing / entering multi-line text in Svr Mgr table view

[JulianUK]

[repost from "svr admin" forum last week - no joy there...]

I have just "upgraded" from SQL Server Enterprise Mgr 2000 to 2005. (I like to be an early adopter...). This was done for no real reason and I wish i'd not bothered.

Anyway, I have some text fields in which I hold some lines of code. In EM2000, opening the table directly allowed me to insert carriage returns using either CTRL or ALT ENTER.

In EM2005 though, it wont even display multiple lines when I stretch down the vertical size of the row.

Is there any way to do this or have they removed a feature?

As I'm still having to use a SS2000 database, it's been one step backwards for me, to be honest!

thanks

Julian

 

[hmckillop]

I have no idea how to fix the problem you are asking, but Enterprise Manager is not really the method for entering data into a SQL Server database.
Why dont you insert your data via an INSERT statement and view it via a SELECT statement?

And in answer to your comment, "its been on step backwards for me, to be honest" - you cant get much more backward that typing data into Enterprise Manager. (sorry I couldnt resist)

"I'm living so far beyond my income that we may almost be said to be living apart

 

[markros]

I like SSMS much more than Query Analyzer and SQL Server 2000 tools.

 

[JulianUK]

Thanks for your comments, but that simply is not what I want to do.

My scenario - I hold Javascript snippits in a database field. I create them in Notepad, and cut n paste them straight into my table. I do it 1 at a time, and maybe a few times a month. Other times, I mod those entries already there.

To insert them using SQL, means I have to convert each snippit into lines. Then I have to convert any single quotes into syntax like
"blah " + Char(39) + "blahvar" + Char(39) + " moreblah"

where before I could've typed directly
"blah 'blahvar' moreblah".

You see how painful that becomes? and more importantly, the margin for error?

You must have requirement to directly type into tables? This is not a programming issue, more of a data management issue.

I could indeed code around it, but why on Earth should I have to?