Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Unable to get more than 8192 characters in Sql 2000, Query Analyser
I have used the option in Sql 7.0 to return 50,000 characters. It is a little inconvenient that this facility has been taken off in SQL 2000, Query Analyser. Thanks all the same for the clarification. Can you advise me on the text functions to be used to consecutively read and display all of...- Varughese
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Unable to get more than 8192 characters in Sql 2000, Query Analyser
Dear All, I have an ntext field in SQL 2000 database which contains upto 50,000 characters. I would like to see this in the Query Analyser. However there seems to be no option to see more than 8192 characters per column in the Query Analyser. Setting the text size also does not help. In Sql...- Varughese
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
-
DTS - DB2/400 to SQL Server 7.0
I am trying to transfer data from a DB2 table on AS400 to SQL Server 7.0 using DTS available in SQL Server 7.0. Using IBM Client Access, when I try to view the data on AS400, I get the message "HResult of 0x80040e09(-2147217911) retuned. Unexpected error...- Varughese
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
