Error Message:
Msg 153, Level 15, State 1, Line 7
Invalid usage of the option %.*ls in the %ls statement.
Severity level:
15.
Description:
This error message appears when you try to use an option in an invalid context.
Consequences:
The SQL statement cannot be parsed and further execution is stopped.
Resolution:
Error of the Severity level 15 are generated by the user and can be fixed by the SQL Server user. Every option must be used within its predefined context.
Versions:
All versions of SQL Server.
Example(s):
CREATE DATABASE abc
ON PRIMARY
( NAME = abc_dat,
FILENAME =’E:abc_dat.mdf’,
SIZE = 0,
MAXSIZE = 0,
FILEGROWTH = ‘15.4%’
)
Remarks:
The root causes for this error messages can be manifold. For example, when you try to use a decimal number in the FILEGROWTH option of a CREATE DATABASE statement.