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

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

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

Leave a Comment

(required) 
(required) 
Submit
Privacy Statement