Re: SQL Server Scema

From: Val Mazur (group51a_at_hotmail.com)
Date: 04/27/04 

Date: Mon, 26 Apr 2004 23:54:17 -0400

Hi,

Use ALTER statement. It allows to alter tables, SPs and other staff without
affecting actual data (unless you delete columns with the data). You could
execute ALTER statements from your application or just prepare batch and run
it in a QA 

-- 
Val Mazur
Microsoft MVP
"alphaCodeWarrior" <anonymous@discussions.microsoft.com> wrote in message 
news:3FFB0322-00B8-46B8-942C-F53B4FD26BC0@microsoft.com...
> Does anyone know the best way to update an existing SQL Server database 
> schema (sprocs, tables, etc.) without affecting data?
>
> I need to update an already installed version of my application, and I do 
> not want to overwrite the user's data.