hi gurus,

i am trying to change a field to have a default value of 'N' , but i keep
getting this error

'TABLE1' table
- Unable to create table.
ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]The name 'N' is
not permitted in this context. Only constants, expressions, or variables
allowed here. Column names are not permitted.

any clues????

Regards,
Vikram Somanathan
Software Engineer
TSG - Solutions Unit

"Work for Excellence Not for Perfection"

MS Sql Server LazyDBA home page