I am very new to SQL Server and I have a quick question. I imported (upsized) a MS Access database to an SQL Server database locally on my computer. However, in the enterprise manager, some of the fields which had a lot of text in them simply says <Long Text> now. WHen I use Dreamweaver to connect to the Database, the content is displayed rather thatn the words <Long Text>. I want to be able to edit the text in the enterprise manager. Is there any way that I can have it display the actual text so that I can edit it???

Think of the <long text> as a container which keeps your text. Your SQL editor / manager should have a way in which you can open this 'container' and edit the text within. This works like MEMO fields in Access or BLOB fields in MySQL.

I'm not familiar with M$QL but if you look around the program there will be a way to edit the field contents.

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

Thanks for the response Poolio,

I understand what it is, but does anyone know HOW I can get in and edit the text. In MS Access, the memo field is completely editable when you are viewing the table. So does anyone know where I go, or what I do to edit the contents of these fields in SQL Server?

Thanks in advance.

Shit, sorry i didn't realise i was explaining something you already knew <img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

apologies for that- i'm not experienced in MSQL, so i wouldn't really know, i only really know MySQL. so i guess this is a totally pointless post (again) and a waste of your good time.

anyway. good luck!

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

ok,

i just asked a MSQL buddy of mine and he says the easiest way he knows is just to make a small edit panel using ASP (or VB) through which you can pull the data from the database and edit it through your own interface.

not much help, but better than nothing...

------------------------
Julio

PHP | MySQL | DWMX

ICQ: 19735247
MSN:

I thought about doing that but it seemed like such a waste of time! I thought that SQL server would have to offer a feature like this to allow you to modify the text in the table.

Anyways, I guess I will follow the advice of your buddy and make a small web based admin site to update the text. It sure seems like a long way to get things done.

Thanks for the help.