:::: MENU ::::

Invalid usage of the option %.*ls in the %ls statement.

  • Jun 11 / 2009
  • 0
Data Modeling and Database Design, dbDigger

Invalid usage of the option %.*ls in the %ls statement.

The following error message
Msg 153, Level 15, State 1, Line 7
Invalid usage of the option %.*ls in the %ls statement.

appears when you try to use an option in an invalid context. Example of such invalid context is when you try to use a decimal number in the FILEGROWTH option of a CREATE DATABASE statement as in below example.

 
CREATE DATABASE abc  
 ON PRIMARY  
 ( NAME = abc_dat,  
 FILENAME ='E:abc_dat.mdf',  
 SIZE = 0,  
 MAXSIZE = 0,  
 FILEGROWTH = '15.4%'  
 )  
Consult us to explore the Databases. Contact us