Pages

Wednesday, August 21, 2013

SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. | Journey to SQL Authority with Pinal Dave

Error Message: Server: Msg 128, Level 15, State 1, Line 3 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. Causes: This error occurs when using a column as the DEFAULT value of another column when a table is created. CREATE TABLE [dbo].[Items] (… Continue Reading...

Source: SQL SERVER – Fix: Error Msg 128 The name is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted. | Journey to SQL Authority with Pinal Dave