THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Tibor Karaszi

New util proc: sp_tableinfo

This blog has moved! You can find this content at the following new location:

Published Sunday, October 10, 2010 2:59 PM by TiborKaraszi



Peter said:

The rowcount seems a bit off when the table contains LOB data.

Try it against:

create table t1 (i1 int, c1 varchar(max))

insert into t1 values (1,replicate('1',8000))

October 11, 2010 6:18 AM

TiborKaraszi said:

Thanks Peter. You are absolutely right. I have modified the procedure to handle BLOB and row overflow data. Hopefully it is more correct now. :-)

October 11, 2010 10:28 AM
New Comments to this post are disabled
Privacy Statement