databasealterations.sql

微软的行业应用解决方案示例

use hardwaredistributor
go

-- switch on change tracking for the database
	ALTER DATABASE hardwaredistributor
	SET CHANGE_TRACKING = ON
	(CHANGE_RETENTION = 2 DAYS, AUTO_CLEANUP = ON)

-- enable tracking on all tables
	ALTER TABLE Customers
	ENABLE CHANGE_TRACKING

	ALTER TABLE DistributionCenters
	ENABLE CHANGE_TRACKING

	ALTER TABLE Employees
	ENABLE CHANGE_TRACKING

	ALTER TABLE Inventory
	ENABLE CHANGE_TRACKING

	ALTER TABLE OrderDetails
	ENABLE CHANGE_TRACKING

	ALTER TABLE Orders
	ENABLE CHANGE_TRACKING

	ALTER TABLE OrderState
	ENABLE CHANGE_TRACKING

	ALTER TABLE Roles
	ENABLE CHANGE_TRACKING

	ALTER TABLE Routes
	ENABLE CHANGE_TRACKING

	ALTER TABLE Trucks
	ENABLE CHANGE_TRACKING

--create stored procedures to get