Skip to content

Instantly share code, notes, and snippets.

@marcelbuesing
Last active August 29, 2015 14:14
Show Gist options
  • Save marcelbuesing/0cbb05c2a03b554a8c96 to your computer and use it in GitHub Desktop.
Save marcelbuesing/0cbb05c2a03b554a8c96 to your computer and use it in GitHub Desktop.
Add missing producedure
/* For Shards */
DROP TABLE [__ShardManagement].[ShardMapManagerLocal]
DROP TABLE [__ShardManagement].[ShardMappingsLocal]
DROP TABLE [__ShardManagement].[ShardsLocal]
DROP TABLE [__ShardManagement].[ShardMapsLocal]
DROP PROCEDURE [__ShardManagement].[spAddShardLocal]
DROP PROCEDURE [__ShardManagement].[spBulkOperationShardMappingsLocal]
DROP PROCEDURE [__ShardManagement].[spFindShardMappingByKeyLocal]
DROP PROCEDURE [__ShardManagement].[spGetAllShardMappingsLocal]
DROP PROCEDURE [__ShardManagement].[spGetAllShardsLocal]
DROP PROCEDURE [__ShardManagement].[spGetStoreVersionLocalHelper]
DROP PROCEDURE [__ShardManagement].[spKillSessionsForShardMappingLocal]
DROP PROCEDURE [__ShardManagement].[spRemoveShardLocal]
DROP PROCEDURE [__ShardManagement].[spUpdateShardLocal]
DROP PROCEDURE [__ShardManagement].[spValidateShardLocal]
DROP PROCEDURE [__ShardManagement].[spValidateShardMappingLocal]
DROP FUNCTION [__ShardManagement].[fnGetStoreVersionMajorLocal]
DROP SCHEMA [__ShardManagement]
/* For ShardMapManager */
DROP TABLE [__ShardManagement].[OperationsLogGlobal]
DROP TABLE [__ShardManagement].[ShardedDatabaseSchemaInfosGlobal]
DROP TABLE [__ShardManagement].[ShardMapManagerGlobal]
DROP TABLE [__ShardManagement].[ShardMappingsGlobal]
DROP TABLE [__ShardManagement].[ShardsGlobal]
DROP TABLE [__ShardManagement].[ShardMapsGlobal]
DROP PROCEDURE [__ShardManagement].[spAddShardingSchemaInfoGlobal]
DROP PROCEDURE [__ShardManagement].[spAddShardMapGlobal]
DROP PROCEDURE [__ShardManagement].[spAttachShardGlobal]
DROP PROCEDURE [__ShardManagement].[spBulkOperationShardMappingsGlobalBegin]
DROP PROCEDURE [__ShardManagement].[spBulkOperationShardMappingsGlobalEnd]
DROP PROCEDURE [__ShardManagement].[spBulkOperationShardsGlobalBegin]
DROP PROCEDURE [__ShardManagement].[spBulkOperationShardsGlobalEnd]
DROP PROCEDURE [__ShardManagement].[spDetachShardGlobal]
DROP PROCEDURE [__ShardManagement].[spFindAndUpdateOperationLogEntryByIdGlobal]
DROP PROCEDURE [__ShardManagement].[spFindShardByLocationGlobal]
DROP PROCEDURE [__ShardManagement].[spFindShardingSchemaInfoByNameGlobal]
DROP PROCEDURE [__ShardManagement].[spFindShardMapByNameGlobal]
DROP PROCEDURE [__ShardManagement].[spFindShardMappingByKeyGlobal]
DROP PROCEDURE [__ShardManagement].[spFindShardMappingByIdGlobal]
DROP PROCEDURE [__ShardManagement].[spGetAllDistinctShardLocationsGlobal]
DROP PROCEDURE [__ShardManagement].[spGetAllShardingSchemaInfosGlobal]
DROP PROCEDURE [__ShardManagement].[spGetAllShardMappingsGlobal]
DROP PROCEDURE [__ShardManagement].[spGetAllShardMapsGlobal]
DROP PROCEDURE [__ShardManagement].[spGetAllShardsGlobal]
DROP PROCEDURE [__ShardManagement].[spGetOperationLogEntryGlobalHelper]
DROP PROCEDURE [__ShardManagement].[spGetStoreVersionGlobalHelper]
DROP PROCEDURE [__ShardManagement].[spLockOrUnlockShardMappingsGlobal]
DROP PROCEDURE [__ShardManagement].[spRemoveShardingSchemaInfoGlobal]
DROP PROCEDURE [__ShardManagement].[spRemoveShardMapGlobal]
DROP PROCEDURE [__ShardManagement].[spReplaceShardMappingsGlobal]
DROP PROCEDURE [__ShardManagement].[spUpdateShardingSchemaInfoGlobal]
DROP FUNCTION [__ShardManagement].[fnGetStoreVersionMajorGlobal]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment