Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to miminize size of table?
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
00544575
Message ID:
00545174
Views:
18
>OK, just out of curiousity, what is the largest ntext value that you have? You can use the DATALENGTH() return the amount of data in a column:
>
I've tried to run this query:
SELECT MAX(DATALENGTH(textcolumn)) FROM thetable
And got error message:
Server: Msg 7102, Level 20, State 99, Line 1
SQL Server Internal Error. Text manager cannot continue with current statement.

Connection Broken
Giedrius
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform