| Author |
Topic |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2006-09-21 : 21:32:36
|
| I have my option set in the query analyzer for results as :Tool->Options->Results->Minimum character per column : 8000I have a text field called emp_complaints in my database in the tbl_emp tableIf I have emp_complaints length greater varchar(8000) in the table.How can I view the complete field in query analyzerand what is the maximum size that the text field can hold? |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-09-21 : 23:29:03
|
| Please let me know if there is any way |
 |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-21 : 23:32:38
|
| Text fields can take anything up to 2GB.If you want to view the data in text fields, I've found Access to be very good at it. Just link in your tables and you should be good to go. |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-09-22 : 00:03:32
|
| Is there anyway we can we view it using sql analyzer |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-22 : 00:20:52
|
| Not that I know of. Why must you use QA?? |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-09-22 : 00:35:48
|
| Because the data is stored in sql server database and to view it we are using sql analyzer.So when I query the records from the sql server database I can view only upto 8000 character.So just want to know whether if there is any other settings I need to view it. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-22 : 00:48:57
|
| I think you're out of luck.You might want to try Access or even Enterprise Manager. |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-09-22 : 00:51:59
|
| If I use the Enterprise Manager to open the table will I be able to view the complete text ? |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2006-09-22 : 03:40:28
|
| Is there any other way to query and view this text information other than the access link table.. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2006-09-22 : 08:19:57
|
| There are lots of apps out there that let you view your data in SQL Server. I suggested Access (use a Data Project or ADP) because I find it very easy to use - more so than Query Analyser |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-23 : 02:03:04
|
quote:
Originally posted by sqllearner
If I use the Enterprise Manager to open the table will I be able to view the complete text ?
No, EM is Worser then QA for viewing data, so dont rely on it.Chirag |
|
|
|
|
Query Analyzer Viewing