This stored procedure marks an existing database and all its existing tables as being excluded from the scope of AutoStats management (or conversely, included in AutoStats scope).
Use this API to make use is equivalent cascading functionality not available in the ALTER TABLE SQL statement.
Required SQL Privileges
- When marking an entire database or user, a MODIFY DATABASE | USER statement is executed by the body of the stored procedure which requires the INVOKER to have the DROP DATABASE or DROP USER privilege on the specified DatabaseName.
- When marking an individual table or when the Cascade option is specified as true, an ALTER TABLE statement is executed by the body of the stored procedure which requires the INVOKER to have the DROP TABLE privilege on the specified TableName.
- EXECUTE PROCEDURE ON TDSTATS