Skip to content

Instantly share code, notes, and snippets.

@KayeeNL
Created September 2, 2021 13:41
Show Gist options
  • Save KayeeNL/101cc006221617128e9106fd5438dae2 to your computer and use it in GitHub Desktop.
Save KayeeNL/101cc006221617128e9106fd5438dae2 to your computer and use it in GitHub Desktop.
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [ServerName]
,[DatabaseName]
FROM [sc10_1_1_Xdb.Collection.ShardMapManager].[__ShardManagement].[ShardsGlobal]
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [ServerName]
,[DatabaseName]
FROM [sc10_1_1_Xdb.Collection.Shard0].[__ShardManagement].[ShardsLocal]
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [ServerName]
,[DatabaseName]
FROM [sc10_1_1_Xdb.Collection.Shard1].[__ShardManagement].[ShardsLocal]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment