Job Management Partner 1/Software Distribution Setup Guide

[Contents][Glossary][Index][Back][Next]

Appendix F.21 LargeSwitchPartition.sql query script

USE [NETMDM_SAMPLE]
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 1 TO netmdm_monitoring_security_arch PARTITION 1
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 2 TO netmdm_monitoring_security_arch PARTITION 2
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 3 TO netmdm_monitoring_security_arch PARTITION 3
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 4 TO netmdm_monitoring_security_arch PARTITION 4
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 5 TO netmdm_monitoring_security_arch PARTITION 5
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 6 TO netmdm_monitoring_security_arch PARTITION 6
GO
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 7 TO netmdm_monitoring_security_arch PARTITION 7
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 8 TO netmdm_monitoring_security_arch PARTITION 8
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 9 TO netmdm_monitoring_security_arch PARTITION 9
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 10 TO netmdm_monitoring_security_arch PARTITION 10
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 11 TO netmdm_monitoring_security_arch PARTITION 11
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 12 TO netmdm_monitoring_security_arch PARTITION 12
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 13 TO netmdm_monitoring_security_arch PARTITION 13
GO
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 14 TO netmdm_monitoring_security_arch PARTITION 14
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 15 TO netmdm_monitoring_security_arch PARTITION 15
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 16 TO netmdm_monitoring_security_arch PARTITION 16
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 17 TO netmdm_monitoring_security_arch PARTITION 17
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 18 TO netmdm_monitoring_security_arch PARTITION 18
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 19 TO netmdm_monitoring_security_arch PARTITION 19
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 20 TO netmdm_monitoring_security_arch PARTITION 20
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 21 TO netmdm_monitoring_security_arch PARTITION 21
GO
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 22 TO netmdm_monitoring_security_arch PARTITION 22
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 23 TO netmdm_monitoring_security_arch PARTITION 23
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 24 TO netmdm_monitoring_security_arch PARTITION 24
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 25 TO netmdm_monitoring_security_arch PARTITION 25
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 26 TO netmdm_monitoring_security_arch PARTITION 26
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 27 TO netmdm_monitoring_security_arch PARTITION 27
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 28 TO netmdm_monitoring_security_arch PARTITION 28
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 29 TO netmdm_monitoring_security_arch PARTITION 29
GO
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 30 TO netmdm_monitoring_security_arch PARTITION 30
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 31 TO netmdm_monitoring_security_arch PARTITION 31
GO
 
ALTER TABLE netmdm_monitoring_security SWITCH PARTITION 32 TO netmdm_monitoring_security_arch PARTITION 32
GO