SQL Server – Management Studio Unable to save changes

-
f you are using management studio and attempt to add a column to a table or some other activity and get a message telling you that you will need to recreate a table, don’t worry.

The message is not clear. What it is trying to say in the message is that data in the table maybe deleted if you add a column to the table.

Management studio has a setting that causes this message. I recommend turning this option off. It can be found in the following location.

Tools-> Options-> Designers-> Table and Database Designers->

Uncheck the option.

“Prevent saving changes that require table recreation”

Comments

Post a Comment

Popular posts from this blog

Authorize.net Integration eCommerce Payment Gateway ( Direct Post Method New! )

-
https://developer.authorize.net/integration/fifteenminutes/csharp These steps assume that your web server is on the public internet and can be accessed via a domain name or IP address. Step 1:Sign up for a Test Account. Sign up for a test account to obtain an API Login ID and Transaction Key. These keys will authenticate requests to the payment gateway. Step 2: Download the Authorize.Net C# SDK and include it in your project Download the SDK Create a new ASP.NET MVC application and add a reference to the AuthorizeNET.dll from the SDK Step 3: Modify web.config. Add the AuthorizeNET.Helpers namespace to the web.config, under system.web/pages: ... Step 4: Create a checkout form that posts directly to Authorize.Net Add the following code to the Home/Index View - this will create a form which will submit a test transaction to Authorize.Net (with hardcoded values). This code uses the SDKs CheckoutFormBuilder to create the form for you - just include your API login and Transa
Read more

Get Organised with OneNote

-
One note is greate tool to get organised and in todays world of information explosion. you may need any set of information weather financial, personal, or expenses or your assets your insurence etc. onenote is the best way and easiest way to manage this info. only thing to do is create templates for eash of these stuffs and you can add info as and when required. you can also, attach the scanned documents with the records in onenotes. For example, monthly phone bill. Below is good link which explains how to utilise onenote and how to find better templates for your use. Click Here
Read more

Test your Sql Query Online

-
Hi Guys i found a good tool to test simple Sql query online the link is as below. This time i used this to test the pivot functionality. The Pivot Sql Function converts the row wise category data into column wise metrix/pivot kind of data. http://www.sqlfiddle.com/#!3/b228e/3 another good example is below http://sqlfiddle.com/#!6/2ba07/131
Read more