Thanks for the responce John, i must apologise but i have never even looked at SQL before the other week. I am still confused as to how to update...

Thanks for the advice, i have just tried to run the update script but get an error when running the following script:

declare @columns table (id int identity(0, 1), tablename sysname,...

Thanks for your responces, and yes it does help if i type correctly!! sorry abou that!!

So i have found my columns to update - not too many of them.  How...

Thanks for the suggestion Peter, i have just run the following as suggested:

Select table_name, column_name

from information_schema.columns

where date_type in ('datetime','smalldatetime')

When i run this in Query Analyzer i get the following message:

Server:...