One of our SQL server databases got moved from MSSQL 7 to MSSQL 2000 and lost its default values in the process. Does anybody know a SQL syntax for adding a default value to an existing field?
TIA
Randy
Randy Hersom
President, Habilitation Software Inc.