Hello, Experts -
I have a SQL Server database in use for an ASP.NET web application. This app has a few users and is in testing mode.
I need to add a new field to two tables in the deployed database, and was wondering what the best method is to do this? I can bring the database down from the server and make the change, then re-deploy it, but am curious if there is a way to do this programmatically?
I'm thinking the answer might be in Stored Procedures, but I haven't used these and don't know how to write an SP or how to run it.
Any suggestions, examples, etc. would be most appreciated -- thank you!