One of my office colleague recently asked me why we are not able to generate ALTER Table script from SSMS. If we right click on the table and choose "Script Table As" ALTER To option would be disabled or Greyed out. Is it a bug? No it isn't a bug. ALTER To is there to be used for generating modified script of Stored Procedure, Functions, Views, Triggers etc., and NOT for Tables. For generating ALTER Table script there is an work around. Right click on the table, choose "Modify" and enter into the design mode. Make what ever changes you want to make and WITHOUT saving it right click anywhere on the top half of the window (above Column properties) and choose "Generate Change Script". Please be advised that SQL Server would drop actually create a new table with modifications, move the data from the old table into it and then drop the old table. Sounds simple but assume you have a very large table for which you want to do this! Then it woul...
Comments
But, I see the whole issue being blown out of proposition. I dont find the point to read too much in between the lines. Allchin has a very good vision for Windows, and an equal good respect for Microsoft as a whole. He is trying to drive a point which he feels the team is missing !! How do we drive a point to a child whose wrong on his/her path? At no point the company has monopolized their claim on running a Windows OS. Now, how many MS employees ripped apart Zune on comparison to iPod? Most of them, and publicly too. They were open to constructive criticism and all these law-suits are looking way too much for such a trivial issue :)
And I feel so bad for Jim Allchin. He is getting targetted repetetively :)A week back, his claim that Vista will be secure with default security features not altered, brought news that 'Allchin recommends No Anti-Virus for Windows Vista' :) I sincerely wish he has a peaceful retirement life for all the good he has done so far!!