Showing posts with label ib4ve. Show all posts
Showing posts with label ib4ve. Show all posts

Sunday, March 25, 2012

DBCC SHOWCONTIG (SQL 7.0)

Hi,
Can anybody tell me how can i put the output of the DBCC SHOWCONTIG into a table in SQL Server 7.0
I=B4ve done yet the same to SQL Server 2000, however i cant do this to run in my servers whith SQL Server 7.0, can you help me.
Theres no output when i execute this:
.
.
insert into frag_tb
exec ('dbcc showcontig ('+ @.objectid + ')') .
.
Best regardsCC&JM,
Yes, DBCC SHOWCONTIG in SQL7 does not have the WITH TABLERESULTS option.
You may be able to output the result into a perl script, and then parse
the results in a scripting language. It aint going to be pretty.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
CC&JM wrote:
> Hi,
> Can anybody tell me how can i put the output of the
> DBCC SHOWCONTIG into a table in SQL Server 7.0
> I´ve done yet the same to SQL Server 2000, however i cant
> do this to run in my servers whith SQL Server 7.0, can you
> help me.
> Theres no output when i execute this:
> .
> .
> insert into frag_tb
> exec ('dbcc showcontig ('+ @.objectid + ')')
> .
> .
> Best regardssql