“Saving changes is not permitted.” SQL Server error when trying to save table changes

Dear All,
Sometime when we tried to save the changes in table of SQL Server we get the error like “Saving changes is not permitted.”  As shown in below figure.

Issue_While_Saving_Image

And when you tried to save the changes it will not save the changes.
To resolve this you need to follow below step
1)    Click on Tools menu
2)    Click on sub menu of tools which is “Options”
3)    Click on designer from open window
4)    Now uncheck “Prevent Saving changes that require table re-creation”.
5)    Now click on Ok button.

As shown in below fig.

Error_reason

Now try to save table changes .It will work.

Enjoy the weekend.

Thanks & Best Regards,
Rajat Jaiswal

Advertisements

Error 5.7.0 Must issue a STARTTLS command first. pu4sm8968093pbb.72 in ASP.NET

Hello friends,

Sometimes when you are trying to send mail through .Net code you will face following error.
5.7.0 Must issue a STARTTLS command first. pu4sm8968093pbb.72

I found 2 main reasons for this.
Port :

Generally SMTP server used 25 port but when you are going with secure server TLS settings then for secure server your Port should be 586

Enable SSL settings:- the second most important reason of showing this error is SSL settings when you sending mail through code. If you are using secure server or TLS settings for mail sending then Enable SSL setting for mail client should be true.
I hope this will resolve your problem too.

Thanks & Best Regards,
Rajat Jaiswal