Is it possible to change the default value of - 1900-01-01 00:00:00.000 for PSDATE column at DB level in SQL Server 2005? If yes please let me know how we can change this.
There was
You could use a default of GETDATE() - which could lead to really bizarre behavior if this is a birthdate…
ALTER TABLE [yourtablename]
ADD CONSTRAINT DF_[yourtablename]_[yourcolumnname]
DEFAULT GETDATE() FOR [yourcolumnname]Or you could use a different date of your choosing
ALTER TABLE [yourtablename]
ADD CONSTRAINT DF_[yourtablename]_[yourcolumnname]
DEFAULT ‘1978-10-20 04:16:00.000′ FOR [yourcolumnname]
When you insert the table default, you’ll have a value other than 1/1/1900 00:00:00.000.