sql server new users: SQL Enterprise manager.. <long text> -- sql server new users

You're in the

sql server new users

group:

SQL Enterprise manager.. <long text>

TriAdX NO[at]SPAM aol.com
3/23/2005 11:19:03 AM

sql server new users:

does anyone know how to get SQL Enterprise manager to display a field that
currenly shows <Long Text>. Is there a Cache setting some where ... or
another way to get it to display those fields with TONS of data?

i want to edit the data through Enterprise manager but cant when it shows

Re: SQL Enterprise manager.. <long text>

Adam Machanic
3/23/2005 2:37:07 PM

You can't; it's a limitation of the tool.

EM is not a good editor anyway -- you should get out of the habit of using
SQL Server like Excel. Start using Query Analyzer and get comfortable with
the INSERT and UPDATE statements.

--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

[quoted text, click to view]

Re: SQL Enterprise manager.. <long text>

TriAdX NO[at]SPAM aol.com
3/24/2005 1:01:04 PM

The thing i like about EM is that i can edit data INSIDE the field without
haveing to update the whole field. This helps because i have so much in those
fields that i dont know whats whats in it to use an UPDATE command

[quoted text, click to view]

Re: SQL Enterprise manager.. <long text>

Adam Machanic
3/24/2005 4:16:09 PM

[quoted text, click to view]

Then write a proper user interface. EM is not a good text editor.

Yes, I know it's more painful, but it will save you in the long run.
Trust me on this. I've seen misuse of EM's editing do way too much
irreparable damage.

--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server new users group.

home · blog · groups

Questions? Comments? Contact the dn