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
Now, I don have idea about it. Please let us know about it.
If it is true, can we consider this step of Microsoft as success of Google?
For example, it has acquired Writely (Online word processor) and you can find details about it here >> http://www.google.com/support/writely
Similarly google has started its beta testing of "Google Spreadsheets" (online version of Spreadsheets).
Whereas what MS now does is just to allow ppl to test drive its MS Office 2007 products online before buying it. I don't think MS in near future would be releasing web based versions of MS Office.