34 lines
6.2 KiB
Transact-SQL
34 lines
6.2 KiB
Transact-SQL
EXEC [hcitools].[delphix].[change_tracking_mgmt] @schema_name='dbo', @maintenance_enabled = 1
|
||
|
||
return
|
||
select *, 'exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='''+DBACTT_table_name+''' , @in_maintMode=2'
|
||
from arizona.dbo.DBA_change_tracking_template
|
||
--exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='all' , @in_maintMode=0
|
||
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Document_header' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Document_line' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PH_prescription_line' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='DL_Posology' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Document_line_link' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='DocumentSignature' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='GoodsReceipt' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='GoodsReceiptLine' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Item_inventory' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Item_quantity' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Item_seasonal_stock_info' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Item_standard_cost' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='LORE_item_ABC_code' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='LORE_supplying_procedure' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='MissedSale' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='OrderRequest' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='OrderRequestLine' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PH_Insurance_card' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PH_insurance_recommendation' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PH_insurance_plan' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PH_patient' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PH_prescription_header' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='Price_modifier' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PurchaseReturn' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='PurchaseReturnLine' , @in_maintMode=2
|
||
exec [arizona].[dbo].[DBA_Change_Tracking_Maintenance] @in_tableName ='WebShopStatusQueue' , @in_maintMode=2
|