I had one table Bug_post having Column bg_desc of type ntext.
when i run query "select top 1 bg_desc from Bug_post" in query analyer.
i m not able to see full data but only upto some length like
bg_desc
------------------------------------------------------------------------------------------------------------------------------------------
select isnull(pr_background_color,'#ffffff'), bg_id [id], bg_short_desc [desc], pj_name [project], ct_name [category],isnull(udf_name,'') [Attribute], rpt.us_username [reported by], bg_reported_date [reported on], pr_name [priority], asg.us_username [assi
(1 row(s) affected)
above data return by query is not complete.
In Front End Data will display properly.
then why i m able to see in query analyer.