What impact will changing the datatype of a column from
smalldatetime to datetime?  Currently, I need to allow for record insertion
where the date may exeed year 2079.

Eric wrote:
That should be fine. The column will require twice the number of bytes
of storage in order to support datetime (8 bytes total). Newly inserted
values will show additional precision unless you account for this.

create table ABC (MyDate smalldatetime)


insert into dbo.ABC values (getdate())
insert into dbo.ABC values ('2005-01-10T14:22:22')
Select * from dbo.ABC
MyDate
-------------------
2005-09-01 17:45:00
2005-01-10 14:22:00

Alter Table dbo.ABC
ALTER COLUMN MyDate DATETIME

Select * from dbo.ABC
MyDate
-----------------------
2005-09-01 17:45:00.000
2005-01-10 14:22:00.000

insert into dbo.ABC values (getdate())
insert into dbo.ABC values ('2005-01-10T14:22:22')

Select * from dbo.ABC
MyDate
-----------------------
2005-09-01 17:45:00.000
2005-01-10 14:22:00.000
2005-09-01 17:46:57.827
2005-01-10 14:22:22.000

drop table ABC

Trouble with SP
SQLDataAdapter.FillSchema() hangs with select on view
Simplifying CHECK constraint
how to rename a temp table
How can I do this without a cursor??