You can run a script...don't drop tables. You should ALTER TABLE instead.
>hi
>what is the best way to update all the changes in the Sql Database of the client, already having data in it.
>By running the script all the data will be lost,so how to update the database with new tables and stored procedures and alteration in existing tables without running the script.
>
>please help me in this regard
>
>Riyaz Patanwala
>Dubai
>U.A.E.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer