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
Friday, May 20, 2011
Tuesday, May 17, 2011
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
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
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.