Buenas a todos,
Estoy migrando unas BD de SQL Server 2000 a 2005 y estoy teniendo problemas
con una sentencia. Se trata de un create default que crea un tipo de cadena
vacía. la sentencia original es:
EXEC dbo.sp_executesql N'CREATE DEFAULT [dbo].[SMSDefaultBlank] as "" '
pero da error al ejecutar en 2005. El error es:
Msg 1038, Level 15, State 4, Procedure SMSDefaultBlank, Line 1
An object or column name is missing or empty. For SELECT INTO statements,
verify each column has a name. For other statements, look for empty alias
names. Aliases defined as "" or [] are not allowed. Add a name or single
space as the alias name.
Msg 128, Level 15, State 1, Procedure SMSDefaultBlank, Line 1
The name "" is not permitted in this context. Valid expressions are
constants, constant expressions, and (in some contexts) variables. Column
names are not permitted.
A ver si me podeis hechar una mano!!
Gracias
Jordi Ullate
Leer las respuestas