Did you just install the new MS SQL 2008 Management Studio ? Its in one of the options, have a tinker and unselect a option selected that says something along the lines of "prevent making changes that require dropping a table". Its abit of a silly one really. But i suppose it stops people accidentally making wrong changes. I cannot remember what the option was (away from my work com), if you still need help just let us know I am sure someone can point you in the right direction.
On May 18, 12:57 pm, "SAMARIS" <[email protected]> wrote: > Thanks for your reply > Regards > > Claude Raiola > SAMARIS.net Software > Email: [email protected] > Mobile 0414 228 948 > Website:www.SAMARIS.net > > -----Original Message----- > From: "Steve Onnis" <[email protected]> > > Date: Mon, 18 May 2009 12:41:15 > To: <[email protected]> > Subject: [cfaussie] Re: Adding Extra Column To SQL Database > > Claude > > Before you do anything, make sure you back up the database. > > To answer your question, it should just add the column in. Depending on how > complex the table change is, sometimes it created a tmp table, puts the data > in there, drops the table, re-creates the table with the changes and adds > the data back in. In anycase you should not loose the data. The only > reason why you may sometimes loose data is if you are changing the column > types of a column. > > Steve > > _____ > > From: [email protected] [mailto:[email protected]] On Behalf > Of SAMARIS Software > Sent: Monday, 18 May 2009 12:32 PM > To: [email protected]; [email protected] > Subject: [cfaussie] Adding Extra Column To SQL Database > > I am using SQL Server Manager to add an extra collum to an existing database > table and when I proceed to save the changes I receive a message telling me > the table I am editing is about to be saved to the database even though it > already exists and has many thousand records contained within it > > I have never come across this before so I am not sure if it is simply > telling me its saving the change to the table structure or is it going to do > overwrite my existing table which clearly I do not want it to do if this > will cause me to loose my existing data. > > Regards > > Claude Raiola > B.Econ (Acc), B.Hot.Mngt. > > Websites:www.AustralianAccommodation.comwww.SAMARIS.NETwww.WebSiteSolutions.com.au > Mobile: 0414 228 948 > > ---~----~----~------~----~------~--~--- --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
