Sharepoint Logging DB leeren

1. DECLARE @TableName AS VARCHAR(MAX)
2. DECLARE table_cursor CURSOR
3. FOR
4. SELECT TABLE_NAME
5. FROM INFORMATION_SCHEMA.TABLES
6. WHERE TABLE_TYPE = 'BASE TABLE'
7. AND TABLE_NAME LIKE '%_Partition%'
8. OPEN table_cursor
9. FETCH NEXT FROM table_cursor INTO @TableName
10. WHILE @@FETCH_STATUS = 0
11. BEGIN
12. DECLARE @SQLText AS NVARCHAR(4000)
13. SET @SQLText = 'TRUNCATE TABLE ' + @TableName
14. EXEC sp_executeSQL @SQLText
15. FETCH NEXT FROM table_cursor INTO @TableName
16. END
17. CLOSE table_cursor
18. DEALLOCATE table_cursor