Ok I get it , so just back up the log file hourly and it won't grow to a point where it just takes space unecessarily. So I should do...

Thanks for the reply...

The TL log seems to grow to several GB and never reduces even after a backup several times a day.

Is there something wrong with th DB ?

Thanks for all the great tips.

I now have to determine the best way to proceed so that our application continues working well after any changes.

I will write back with more...

Thanks for that... it does indeed seem ugly and we will most probably keep existing collation for the present tables and all.

I will let you know of any questions.

Much appreciated

Thanks for your reply...

So basically I will have to backup and restore the database but reinstall 2005 first with the correct collation and then restore the database with the proper...