> Do you know of any products that can give a complete database table stucture instead of the copy paste method. We have several tables and i would like to automate this process.

ERWin is my favorite but it's very expensive. Just about any ER tool that can connect to SQL Server should be able to perform the function that you want.

-Mike