MSSQLWIKI

Karthick P.K on SQL Server

Posts Tagged ‘SQL Server management studio’

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

Posted by Karthick P.K on July 31, 2010

Error

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
cant be re-created or enabled the option Prevent saving changes that require the
table to be re-created.

Resolution

SQL Server management studio—> Tools –>Options—> Designers –>Table and database designers –>Uncheck “Prevent saving changes that require table recreation”

image

Note: Some operations such as alter column will drop and recreate table. Ensure you do not abort SSMS while operation in progress. You might loose the table. I would recommend

script the changes and and run script in query window (or) At least review the script before you save changes using SSMS.

Thanks

Karthick P.K

Posted in SQL Server Tools, SSMS | Tagged: , , | 2 Comments »

“Value cannot be null” when i connect SQL Server from SSMS

Posted by Karthick P.K on May 26, 2010

I get this below when I connect to SQL Server using SSMS…… What should i do?

Error

Value cannot be null.
Parameter name: viewInfo (Microsoft.SqlServer.Management.SqlStudio.Explorer)

Resolution

Right click SSMS   “run as administrator”   🙂

If the “run as administrator doesn’t resolve the problem verify if %Temp% environment variable to set properly for the logged on widows account

If %Temp% is not set properly in environment variables we might end up with error.

If you liked this post, do like us on FaceBook at https://www.facebook.com/mssqlwiki and join our FaceBook group https://www.facebook.com/mssqlwiki#!/groups

Thank you,

Karthick P.K |Technical Lead | Microsoft SQL Server Support  |My Facebook Page |My Site| Blog space| Twitter

Posted in SQL General, SQL Server Tools, SSMS | Tagged: , , , , , , | 13 Comments »

 
%d bloggers like this: