[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 268
  • Last Modified:

Listing out indexes of all databases of all servers

My requirement is to excute a job from a centralised server which lists out indexes of all databases of all servers. Please help me out to achieve this.
0
SQLM_M
Asked:
SQLM_M
1 Solution
 
Pratima PharandeCommented:
try this

SELECT DISTINCT      TABLE_NAME,      INDEX_NAME  FROM INFORMATION_SCHEMA.STATISTICS


Also this will you some more infor about schema etc

SELECT * INFORMATION_SCHEMA.STATISTICS
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now