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?