Author: Eriksson Joakim, Teknikhuset AB.

Published: 2004-04-30

Applies to:
  • Content Studio ver. 4.0 and later

Type: How to

More information

Starting with Content Studio version 4.0 RC2 the feature Document Quota has been introduced. Document quota is not enabled by default but can be enabled on a single category basis. If document quota is set to a certain value (ex. 2000) Content Studio will not allow more than 2000 documents to be created in the affected category. NOTE Only administrators with a thorough knowledge of Microsoft SQL server should try to change document quota settings To enable or change Document Quota you must have access to the Content Studio site database tables and must have permission to change data in the dbo.tbl_Categories table. Before you start you must know the name of the site database and the ID of the category to change quota for. In a database editor tool (ex. Query analyzer) run the following query against the site database:

DECLARE @Quota int, 
        @CategoryID int;
SELECT @Quota = NewQuota, 
       @CategoryID = CategoryID 
UPDATE dbo.tbl_Categories 
SET DocumentQuota = @Quota WHERE CategoryID = @CategoryID

Replace the NewQuota and CategoryID with the actual values before running the script. A DocumentQuota value of 0 will disable document quota for the actual category.