How to add SQL Coloumn to over 3k tables

Running visual studio 2005, need to add a date column to over 3000 tables in an SQL db. How can i go about doing this programmatically instead of manually? I know there is a script to do something like this, but I’m not entirely sure how or where to run it at. HELP!!!! Thank you!