THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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:

http://sqlblog.karaszi.com/new-util-proc-sp_tableinfo/

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

Comments

 

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