-
column size for ntext
Hi,
Please help me to find out the ntext column size in a table.
Thanks in advance
Regards
Karthik
-
You can find the actual space used from sysindexes table. Look for indid=255
-
Sysindexes tells you how many pages used for ntaxt, taxt and image colunms in the table. You may need divide the number of pages by row counts and number of those kind of columns in the table to get rough idea of average column length of those columns.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|