Microsoft SQL Server Management Studio 2008 R2 does not allow saving changes to table structures that requires the table to be re-created

Default Microsoft SQL Server Management Studio 2008 R2 does not allow saving changes to table structures that requires the table to be re-created, like inserting a new column at a specific position or changing the data type of a field. The saving process is aborted with the following error dialog:




You can change this behavior by unchecking the option
Tools > Options > Designers > Prevent saving changes that require table re-creation

HTTP Error 500.19 - Internal Server Error

From last two time installation and configuration IIS 7.0 on windows Server 2008 R2 I am having issue after application configure application IIS .. which showing error "HTTP Error 500.19 - Internal Server Error".



I tried different way to solved issue but for me following worked both time
Solution :
Try 1 : I added IIS_IUSER permission to Application - did not work.
Try 2 : Application pool --> Adavance Setting -- > Identity changed to Local System, Local Service, Network Service or IdentityAppPool... - did not work
Try 3 : I added Permission to Local Server\User and It worked..as charm :)
(Windows Authentication on and Anonymous off)







Try other Solutions might work for you
1)http://social.msdn.microsoft.com/Forums/en-US/dotnetstocktradersampleapplication/thread/6e79cb01-ffb0-439c-8e1c-505a29b87671
2) http://www.youtube.com/watch?v=vBNoTK31zPo
3) http://www.winservermart.com/Howto/HTTP_Error_500_19_IIS_7.aspx
4) http://forums.iis.net/p/1073585/1867893.aspx

I am not Windows / IIS Guru... I worked mostly Architect application, design and implementation ... but I try to figure out issue rather waiting for 2-3 days... and here what i found... updated me if something wrong or not feasible solution.. I am happy to improve myself.