SQL server query question

[ToMo]

At work, when I am trying to access records from our SQL server, there is one field that is set up as VarChar and its a pretty long entry. We have it set up to 2200 characters. The thing is when I try to do a copy/paste from the field, I only get half of the field. When the data is accessed using ASP, it pulls out the entire entry. Is there a copy limit on SQL server from records? Is there a way to bypass this without having to access the data using asp/vb(maybe a table setting)? When I am trying to pull up this info its usually while I'm on the phone with a customer and it would be too much to have to access the information in that manner if I cant figure out how to get it directly from the SQL database. Anyone?

[Geforce255]

Originally posted by ToMo
At work, when I am trying to access records from our SQL server, there is one field that is set up as VarChar and its a pretty long entry. We have it set up to 2200 characters. The thing is when I try to do a copy/paste from the field, I only get half of the field.

Enterprise manager is pretty limited, and meant for very light tasks. Also, the clipboard has some limitations on what can be saved.

The easiest way around your problem is to use the Transact query analyzer. You can create a query using EM, and post the code into query analyzer if you don't know SQL well. Then simply change the output from a grid to a file, and you'll get the entire string in text format.

[ToMo]

I found out that even though the character limit was set high enough, there is another setting I found which is the display limit. Fixed my problem right up, but thx for the reply anyhow!