Sp_help on all tables in a db at once? - TechRepublic
General discussion
April 6, 2001 at 08:44 AM
rvanderveer

Sp_help on all tables in a db at once?

by rvanderveer . Updated 25 years, 2 months ago

We are trying to get information on a client’s SQL Server that is exhibiting some performance problems. We are doing this remotely with pcAnywhere. We wanted to get the sp_help information but for all the tables at once, in other words in a batch orsp or something, so we wouldn’t have to run it on hundreds of tables one at a time.
Anyone have an idea or a script they would like to share?

This discussion is locked

All Comments