Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL Error

Author  Topic 

Pras
Starting Member

10 Posts

Posted - 2008-05-21 : 17:35:00
Hi,

I have a column of ntext datatype in SQL database. I am trying to do some string manipulation with this particular column. But i am getting a error

Expression result length exceeds the maximum. 8000 max, 16000 found.

when i do the same operation in SQL Server 2005 it is working successfully. Can anyone tell me what problem is this? Why i am getting this error only in SQL Server 2000?



SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-05-21 : 17:35:59
There is an error in line 4 of your code.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -