Restore a database to different databases without losing any data I work on a database structure that has a lot of data in it.  This database structure is used by approximately 40 different servers.  I want to change some of the table structures, by adding some columns to tables, etc, but I do not have time to change 40 database structures.  

How can I change all databases structure without losing any data with a script?  

Can I backup a database structure without data and restore it to the other servers without them losing their data?

The servers are Microsoft SQL Server 2005.
You cannot backup the structure and restore that structure to another DB using SSMS; though there are third party tools that can help you, like Redgate's SQL compare which I have used previously for this. 

One suggestion is to save your TSQL scripts, and then you can apply these scripts to the other DBs by using Powershell. 

Another option is to use SQL CMS, but you will need at least one designated SQL 2008 instance.