USEFUL SITES :
Write for Us
Error Message: Msg 15143, Level 16, State 1, Line 27 '%s' is not a valid option for the @updateusage parameter. Enter either 'true' or 'false'.
Severity level: 16.
Description: This error message appears when you try to use an invalid option for the @updateusage parameter of the sp_spaceused procedure.
Consequences: The T-SQL statement can be parsed, but causes the error at runtime.
Resolution: Errors of the Severity Level 16 are generated by the user and are corrigible by the user. The statement cannot be executed this way. Valid values for the @updateusage parameter are only 'TRUE' and 'FALSE'.
Versions: All versions of SQL Server.
Example(s): USE Northwind; EXEC sp_spaceused @objname = N'Northwind', @updateusage = 'TREU'
Remarks: in the above example we try to execute the sp_spaceused procedure with the invalid value "TREU* for the @updateusage parameter. This raises the error.