Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. SQL Server Management Studio 2008

Error Details:

Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created. You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.

You need to Disable “Prevent Saving Changes that requires the table re-creation”.

  1. Open SQL Server Management Studio (SSMS) 2008
  2. Click ‘Tools’ Menu
  3. Then Click ‘Options’ as shown
  4. In the navigation pane of the Options window, expand Designers node and select Table and Database Designers option as shown in the below snippet

Risks of Turing Off “Prevent Saving Changes that Require Table Re-creation” in SSMS
If you turn off this feature then you can avoid table recreation. However, if you have the Change Tracking feature of SQL Server 2008 enabled to track the table changes then the change tracking information will be lost completely whenever table is recreated. So, it is always advised to use this feature very carefully especially in a production environment.

Advertisements

Password Encryption Using ASP.Net

Password Encryption can be used for encrypting password. Here in this article I am going to explain how you can create the hashed passwords. This method can be used for storing passwords in the credentials section of a database or inside an XML file.

Some of commonly used Hash Encryption Algorithms are ‘MD5‘ and ‘SHA-1

SHA-1 (Secure Hash Algorithm 1) is slower than MD5 but the message digest is larger, which makes it more resistant to brute force attacks. Therefore, it is recommended that Secure Hash Algorithm is preferred to MD5 for all of your digest needs.

Creating Hashed Passwords Using “SHA-1” (Secure Hash Algoritham)

  • Source Code “VB.NET”

    Dim strEncryptPassword As String
    strEncryptPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, “sha1”)

  • Source Code “C#”

    {
    string strEncryptPassword;
    strEncryptPassword = FormsAuthentication.HashPasswordForStoringInConfigFile(txtPassword.Text, “sha1”);
    }