Create the webapp

First, Let’s see how to create a new ASP.NET Core web app using the .NET Core CLI tool:

dotnet new webapp -o MyFirstAspNetCoreApp

This command creates a new web app. The -o MyFirstAspNetCoreApp parameter creates a directory named MyFirstAspNetCoreApp with the source files for the app.

Now, let’s examine the source files that are created:

We have successfully created an ASP.NET Core web app.

Trust the certificate

The .NET Core SDK includes an HTTPS development certificate. Installing the .NET Core SDK installs the ASP.NET Core HTTPS development certificate to the local user certificate store. The certificate has been installed, but it’s not trusted. To trust the certificate, we need to perform a one-time step to run the dotnet dev-certs tool:

dotnet dev-certs https --trust

A confirmation prompt will be displayed if the certificate was not previously trusted. We need to click Yes on the prompt to trust the development certificate. If a valid HTTPS certificate is already present, it will display the corresponding message and we can continue:

Build the app

The next step is to build the app. We can use dotnet build command for that:

dotnet build

This will build the project and we can see the build output generated as dlls. Perfect.

Run the app

We have created an ASP.NET Core web app and built it using the .NET Core CLI tool. Now, it’s time to run and see it in action. We can do that by using the dotnet run command. Let’s add an optional watch command to monitor the file system for any changes in the source code. If there are any changes, it will build and run the app again:

dotnet watch run

Now let’s browse the app by navigating to https://localhost:5001/:

We can see a welcome page that uses the default template of ASP.NET Core.

Now, let’s modify the default text on the web page:

@page
@model IndexModel
@{
    ViewData["Title"] = "Home page";
}

<div class="text-center">
    <h1 class="display-4">Welcome</h1>
    <p>Hello, Welcome to my first ASP.NET Core App</p>
</div>

Since we are watching the file system for changes, it will detect the change, build, and run the app once again:

Let’s refresh the webpage:

We can see that the webpage is updated with our changes.

Cool! We have learned how to create and run an ASP.NET Core web app using the .NET Core CLI.

Conclusion 

We have learned the following topics in this article:

• Create an ASP.NET Core app using .NET Core CLI tool
• Trust the development certificate
• Build, run and watch for changes
• Modify a web page

ASP.NET Core is a new framework developed from the scratch. It combines several previously separate frameworks like ASP.NET MVC, ASP.NET Web API, etc into a single programming model. Furthermore, this is a redesign of ASP.NET 4.x, which includes several architectural changes that result in a lean, modular, and extensible framework.

Development Tools

With ASP.NET Core, we have the choice of many different development tools on Windows, macOS, and Linux. Visual Studio, Visual Studio Code, etc are Microsoft tools and they are available for various Operating Systems. Rider, OmiSharp, etc are third party components that work well on various platforms as well. Additionally, we have the .NET Core Command-Line Interface (CLI), a cross-platform tool for developing, building, running, and publishing .NET Core applications. The .NET Core CLI is included with the .NET Core SDK.

Application Types

ASP.NET Core provides features to build different types of applications. Let’s quickly look at the major types of apps that we can build using ASP.NET Core.

ASP.NET Core Razor Pages is a new server-side web UI development technology. It is a page-based programming model that makes building web UI easier and more productive.

ASP.NET Core Web API helps us to build RESTful HTTP services. It has built-in support for multiple data formats and content negotiation. This lets our web APIs reach a broad range of clients, including browsers and mobile devices.

ASP.NET Core MVC provides features to build web apps using the popular Model-View-Controller (MVC) pattern. This helps us to achieve separation of concerns and make our apps more testable.

ASP.NET Core integrates seamlessly with popular client-side frameworks and libraries, including Blazor, Angular, React, and Bootstrap.

.NET Core gRPC is a language-agnostic, high-performance Remote Procedure Call (RPC) framework. It enables client and server applications to communicate transparently, and simplifies building connected systems.

ASP.NET Core SignalR simplifies adding real-time web functionality to apps. Real-time web functionality enables server-side code to push content to clients instantly.

In the next article, we’ll look at how to build an ASP.NET Core app using the .NET Core CLI tool.

Scenario

                            Web Services are undoubtedly one of the most reliable solution when we need to integrate an external functionality in our application. Usually we integrate web services in our application through server side code. In some situations, we would need to call a web service from our client side script and then update the web page with the result without refreshing the page. The below steps describes this method which is a pretty straightforward task.

Solution

We can make use of AJAX functionality built into ASP.NET for achieving this functionality.         

First of all, for this method to work, the web service and client page should be in the same domain.

Imagine we have a simple web service called TempConversion.asmx that takes a Fahrenheit value and returns its Celsius equivalent.

Following are the steps required to set up your Web service and an AJAX client page.

• Mark the web service with ScriptService attribute.

[System.Web.Script.Services.ScriptService]
public class TempConversion : System.Web.Services.WebService
{
    [WebMethod]
    public float GetCelsius(float temperature)
    {
        return (5 / 9f) * (temperature – 32);
    }
}

This indicates that the Web methods inside the Web service can be called from client script.

• Register the HTTP Handler ScriptHandlerFactory inside the Web.config file, If not already done.

<httpHandlers>
  <remove verb="*" path="*.asmx" />
  <add verb="*" path="*.asmx" validate="false"
  type="System.Web.Script.Services.ScriptHandlerFactory" />
</httpHandlers>

• Add a ScriptManager control to your client page and to set a ServiceReference pointing to the XML Web service (.asmx file)

<asp:ScriptManager runat="server" ID="ScriptManager1">
    <Services>
        <asp:ServiceReference Path="TempConversion.asmx" />
    </Services>
</asp:ScriptManager>

• Add a JavaScript method to your page to call the web service functionality.
• Optionally, you can add another JavaScript method to your client page to serve as the
  callback handler.

<script type="text/javascript">

    function GetCelsius()

   {
        var val = document.getElementById("TextBoxTemp");
        TempConversion.GetCelsius(val.value, FinishCallback);
    }

    function FinishCallback(result)

    {
        var results = document.getElementById("LabelResults");
        results.innerHTML = result;
    }

</script>

Finally let us add the controls to the web page.

Enter Fahrenheit Temperature:

<br />
<asp:TextBox ID="TextBoxTemp" runat="server"></asp:TextBox>&nbsp;
<asp:Label ID="LabelResults" runat="server" Text=""></asp:Label>
<br />
<input id="Button1" type="button" value="Calculate" onclick="GetCelsius()" />

Here we can see that the GetCelsius JavaScript method defined earlier is called when
the user clicks the Calculate button. This triggers the Web service. The results are returned
to the FinishCallback JavaScript method and then displayed in the Label control.

Figure below shows the call in action.

Conclusion

                                  For those who haven’t explored this feature yet, This is a handy feature built into ASP.NET AJAX for calling a web service from client side script with minimal coding effort. Do share your thoughts, comments and suggestions. Have a good day and happy programming !!!

On seeing this, a lot of thoughts flashed through my mind in an instant.

I had heard this title before. I remembered that lately I had seen some people recognized with the “Microsoft Community Contributor” award for their notable contributions to the online community.

But wait, Could this be that? No way!!! I don’t remember having done anything notable recently. To be frank, I haven’t been much into online communities for last 6-8 months.

Before that,  yes I was a bit active in ASP.NET forums and have helped some people with some queries. Apart form that I have participated in some user group activities and written a very few articles in my blog. That is all I have done in my past. So could this be a recognition for that?

All these thoughts came to my mind even before opening the mail. I wasted no more time and opened the mail to find the below content.

Dear Contributor,
Congratulations again for being recognized with the Microsoft Community Contributor Award!
The Microsoft Community Contributor Award is reserved for participants who have made notable contributions in Microsoft online community forums such as TechNet, MSDN and Answers. The value of these resources is greatly enhanced by participants like you, who voluntarily contribute your time and energy to improve the online community experience for others.
Becoming a Microsoft Community Contributor Award recipient includes access to important benefits, such as complimentary resources to support you in your commitment to Microsoft online communities. To find out more about the Microsoft Community Contributor Award and to claim your recognition, please visit this site: http://www.microsoftcommunitycontributor.com/

Thank you for your commitment to Microsoft online technical communities and congratulations again!

Nestor Portillo
Director
Community & Online Support, Microsoft

No words can express my feelings after reading this. I was at the same time very very happy and also sorry that I was no more active in community these days.

If Microsoft recognizes smallest of efforts like those of mine in such a way, I think I am bound to give back a lot more to the community.

So that’s it guys. I have made up my mind to be active in community activities, both online and offline and service the community in the best way I can.

After all, awards does boost our morale

PS:- This award comes with a certificate, a badge and 12 months subscription to MS Press online reference

For details and registration :-

http://k-mug.org/content/ctd11.aspx

Regular Expressions through .Net – Part 1

• Introduction
• Basics
• Using Regular Expressions for Pattern Matching

Introduction

For decades, UNIX and Perl developers have used a complex but efficient technique
for processing text: Regular Expressions. A regular expression is a set of
characters that can be compared to a string to determine whether the string meets
specified format requirements. You can also use regular expressions to extract portions
of the text or to replace text. Regular Expressions is still the most efficient
way for processing text and in this article, we’ll look into how we can use Regular
Expressions for text processing in .Net.

This is what Tony Northrup, author of more than a dozen technology books
on the topics of development and networking and dozens of articles at http://www.microsoft.com,
covering topics ranging from securing ASP.NET applications to designing firewalls
to protect networks and computers, says about Regular Expressions in one of his
books.

            "I’m often stubborn to a fault. For many years, I simply refused to learn regular expressions.
Regular expressions were the UNIX way of doing things, and I was a Windows guy.
            Recently, I reviewed some code I wrote several years ago when I was still being stubborn.
I had written dozens of lines of code to check the validity of text data that could have been written
with a singular regular expression. That doesn’t bother me in itself, because sometimes writing more code
improves readability. However, in this case, the text checking had gotten so complex that the textchecking
code contained bugs.
            I rewrote the code using regular expressions, and it not only fixed the bugs, but it simplified the code.
So, for your own sake, don’t ignore regular expressions just because they seem overly complex. Dive in,
spend a few hours working with them, and you won’t regret it."

I think same is the case with most of us .Net developers out here. We simply
refuse to learn Regular Expressions because it seems overly complex. But
once we spend a few hours working with them, Regular Expressions will be
the first thing to come into our mind whenever we think of text processing.

Through this article we’ll try to pick up some basics of Regular Expressions
in .Net

Basics

Regular expressions enable you to determine whether text matches almost any type
of format. Regular expressions support dozens of special characters and operators.
The most commonly used are

Below Table summarizes characters that can be used to match special characters in
a string.

The below table summarizes the regular expression characters used to match multiple
characters or a range of characters.

Some symbols used in Regular Expressions

Using Regular Expressions for Pattern Matching

For tesing Regular Expressions, Let’s create a console application which
accepts two strings as input and determines whether the first string (a regular
expression) matches the second string. The following code, which uses the System.Text
.RegularExpressions namespace, performs this check using the static System.Text
.RegularExpressions.Regex.IsMatch method and displays the results to
the console:

        public static void RegExPatternMatching()
        {
            Console.Write("Enter regular expression: ");
            string regularExpression = Console.ReadLine();
            Console.Write("Enter input for comparison: ");
            string input = Console.ReadLine();
            if (Regex.IsMatch(input, regularExpression))
                Console.WriteLine("Input matches regular expression.");
            else
                Console.WriteLine("Input DOES NOT match regular expression.");
        }

As this code demonstrates, the Regex.IsMatch method compares a regular expression
to a string and returns true if the string matches the regular expression. In this
example, ^\d{5}$ means that the string must be exactly five numeric digits. The
caret (^) represents the start of the string, \d means numeric digits, {5} indicates
five sequential numeric digits, and $ represents the end of the string.

Now, If you remove the first character from the regular expression, you drastically
change the meaning of the pattern. The regular expression \d{5}$ still matches valid
five-digit numbers, such as 12345. However, it also matches the input string abcd12345
or drop table customers – 12345. In fact, the modified regular expression will match
any input string that ends in any five-digit number.

If you want to match text beginning at the first character of a string, start the
regular expression with a caret (^) symbol. For example, the regular expression
^abc matches the strings abc and abcde, but it does not match
yzabc. To match text that ends at the last character of a string, place a
$ symbol at the end of the regular expression. For example, the regular expression
abc$ matches abc and yzabc, but it does not match abcde.
To exactly match a string, include both ^ and $. For example, ^abc$ only
matches abc and does not match abcde or yzabc. When searching
for words, use the metacharacter \b to match a word boundary. For example, car\b
matches car or tocar but not carburetor. Similarly, \B
matches a nonword boundary and can be used to ensure that a character appears in
the middle of a word. For example, car\B matches carburetor but not tocar.

You can also use regular expressions to match repeated characters. The * symbol
matches the preceding character zero or more times. For example, to*n matches
ton,
tooon, or tn. The + symbol works similarly, but it must match one or more times.
For example, to+n matches ton or tooon, but not tn.

To match a specific number of repeated characters, use {n}, where n is a digit.
For example, to{3}n matches tooon but not ton or tn. To match a range of repeated
characters, use {min,max}. For example, to{1,3}n matches ton or tooon but not
tn
or toooon. To specify only a minimum, leave the second number blank. For example,
to{3,}n requires three or more consecutive o characters.

To make a character optional, use the ? symbol. For example, to?n matches
ton or
tn, but not tooon. To match any single character, use the period (.). For example,
to.n matches totn or tojn but not ton or tn.

To match one of several characters, use brackets. For example, to[ro]n would match
toon or torn but not ton or toron. You can also match a range of characters. For
example, to[o-r]n matches toon, topn, toqn, or torn, but it would not match
toan
or toyn.

To match a group of characters, surround the characters with parentheses. For example,
foo(loo){1,3}hoo would match fooloohoo and fooloolooloohoo but not
foohoo or foololohoo.
Similarly, foo(loo|roo)hoo would match either fooloohoo or fooroohoo. You can apply
any wildcard or other special character to a group of characters.

Well. I hope that is more than what a beginner can digest of Regular Expressions in one stretch. In the next part, We would try to learn more advanced topics like Back-referencing, Specifying Regular Expression options, Extracting matched data etc.

DevCon 2010 – Day 2 (4th Sept- Saturday) at ParkCenter, Technopark, Trivandrum

Why attend DevCon 2010?

Because you’ll return to the office with cutting-edge insights and expertise that will make life easier for you (and everyone else) at work. Immerse yourself in IT learning opportunities and get your questions answered by renowned technology experts. Even more importantly, engage and collaborate with Microsoft MVPs and thousands of your IT peers, building connections that will last beyond your two days at DevCon.

When

04 – Sept 2010

Where

ParkCenter, Technopark, Trivandrum, Kerala, India

Sessions

08:30AM – 09:30AM – Registration Confirmation
09:30AM – 10:30AM – Functional programing with F#
10:30AM – 11:30AM – Power Shell – Your Wish is my Command
11:30AM – 11:45AM – Tea Break
11:45AM – 12:00PM – Visual Studio 2010 tips
12:30PM – 01:15PM – ASP.NET MVC2
01:15PM – 02:00PM – Lunch
02:00PM – 02:45PM – Great Developer Contest – Final
02:45PM – 03:45PM – Office Addins with Visual Studio 2010
03:45PM – 04:30PM – Entity Framework 4
04:15PM – 05:00PM – Closing Ceremony

Register

Note:

Online registration is only to get the entry pass to registration counter at the venue. Registration desk at the venue will provide the tickets to the conference hall (with limited seats) based on first-come-first-serve.

Event Details

http://k-mug.org/events/devcon2010/

• Introduction
• Definitions
• Practical Usage
• Conclusion

Introduction

From version 2005 onwards, SQL Server supports 3 functions for retrieving last inserted Identity value. They are

• @@IDENTITY
• SCOPE_IDENTITY()
• IDENT_CURRENT

Actually these three methods serve different purposes and are meant to be used in different situations. But in most of the situation, we make a blind choice of using @@IDENTITY whenever we want to retrieve last inserted identity value. Later on we start getting unexpected results and that is when we start wondering what went wrong. So let’s look into each of these in detail and see when to use each.

Definitions

@@IDENTITY

Returns the last identity values that are generated in any table in the current session. Here current session denotes current connection.

SCOPE_IDENTITY

Returns the last identity value inserted into an identity column in the same scope. Here a scope means a stored procedure, trigger, function, or batch.

IDENT_CURRENT

Returns the last identity value generated for a specified table or view. The last identity value generated can be for any session and any scope.

Confusing enough? Let’s try out these functions and see the results for ourselves.

Practical Usage

First of all let us create 2 tables – Orders and OrderLog.

CREATE TABLE Orders
(
	OrderID bigint IDENTITY(1,1),
	OrderName varchar(50)
)

CREATE TABLE OrderLog
(
	OrderLogID bigint IDENTITY(1000,5),
	OrderID bigint
)

Here [Orders] table has identity values starting at 1 with an increment of 1 while [OrdersLog] has identity values starting at 1000 with an increment of 5.

Now let us create an after insert trigger for Orders table for making entries in OrderLog table.

CREATE TRIGGER Order_After_Insert_Trigger
	ON Orders
AFTER INSERT
AS
	BEGIN
		INSERT INTO OrderLog
		SELECT OrderID FROM INSERTED
	END
GO

Now let us insert a record into Orders.

INSERT INTO Orders
VALUES
('Order1')

SELECT * FROM Orders
SELECT * FROM OrderLog

Now our tables look like this

Now let’s check what each of our system functions return.

SELECT @@IDENTITY AS [@@IDENTITY]
SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]
SELECT IDENT_CURRENT('Orders') AS [IDENT_CURRENT]

Here @@IDENTITY returns the identity value generated by trigger because that is also in the current session. But it is out of current scope and hence not considered by SCOPE_IDENTITY(). IDENT_CURRENT is not bothered about session and scope. It just returns the last generated identity value in the given table.

Now let’s open a new session to the server. Opening a new query window will open a new session with the server.

Now we’ll insert a new record to the Orders table and check values for our system functions through this new session.

INSERT INTO Orders
VALUES
('Order2')

SELECT @@IDENTITY AS [@@IDENTITY]
SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]
SELECT IDENT_CURRENT('Orders') AS [IDENT_CURRENT]

Now our tables look like this

And our system functions show values as expected.

So far so good.

Now lets go back to our first query window and check values for system functions.

SELECT @@IDENTITY AS [@@IDENTITY]
SELECT SCOPE_IDENTITY() AS [SCOPE_IDENTITY]
SELECT IDENT_CURRENT('Orders') AS [IDENT_CURRENT]

Here since @@IDENTITY and SCOPE_IDENTITY are interested only in events happening within the current session, They still show the previous values. But IDENT_CURRENT is not limited by Session or Scope. It just returns last generated identity value for that particular table.

Conclusion

So we’ve just went through the different Identity functions available in SQL Server. We have gone through the differences between each of them with examples and can now easily make the right choice from them depending upon the situation.

So that’s all for now, Guys.

Thanks for reading the article.

Do post your Comments, Suggestions and Views.

Have a nice day and happy programming !!!

Recap

                  DevCon-2010 was a two day developer conference organized by Kerala Microsoft User Group (K-Mug). The event was originally  scheduled as a two day event to be held on on 3rd and 4th of July 2010 with about 14 core technical sessions by Technology experts on various verticals. K-Mug had also organized some cool contests as part of the event. All tickets were sold out pretty soon after registration started and about 250+ participants were expected for the event.

You can view the event details here

The Event

                    Finally the big day came. DevCon team reached Park Center early morning and started arrangements. Registration was started by about 8.30 AM. and was almost completed by 9.30. There have been some last minute cancellation by many participants and venue was only half occupied. Audience was a right mix of professionals ranging form junior developers to seasoned veterans, Analysts, Architects, Administrators, Trainers and Students. The event was also streamed live. Due to some unforeseen reasons, there was major shortage of participants which forced K-Mug to cut short two day program to a single day. As a result schedule for some sessions had to be cut short.

                      Sreejumon started of the sessions with the welcome speech. This was followed by Janakiram’s Key Note Session on  “Cloud – The Meta Platform”. He explained the concepts of cloud computing with special focus on Windows Azure platform. He put across the  theoretical aspects in a very nice way and promised another walkthrough session afternoon.

                     Janakiram’s session was followed by Anoop Madhusoodhanan’s session on “New features in .NET 4.0 & Visual Studio 2010”. The “Amazed saint” really fascinated audience by some of the very cool features in Visual Studio 2010 and .Net framework 4.0. However due to time limit, He had to cut short his session a little bit. After the session, there was a small tea break.

                       When the sessions resumed after the tea break, Ramaprasanna took audience into the world of “Robotics Programming”. He demonstrated the Simulation of robotics applications in 3D physics-based virtual environments. He also showed videos of his hobby project titled “Buddy home”. The audience were really fascinated by the presentation.

                      Ramaprasanna’s session was followed by Manu Zacharia’s session on “Web Security and Security Auditing”.He shed light on many hacking incidents which happened in recent times and also gave tips on how to be secure on the web. After Manu’s session, participants parted for a short lunch break.

                          First post lunch session was by Vijay Raj who is popularly known as “msigeek”. He took a wonderful session on “Managing Application Compatibility in Windows 7”. He talked about Microsoft Application compatibility Toolkit, Shim etc along with other topics and demonstrated some cool ways of addressing compatibility issues.

                     Vijay’s session was followed by Janakiram who demonstrated a walkthrough of creating a deploying a cloud application. He created a twitter like application with a web and windows interface which also used WCF for communication. By the end of his presentation we had  the application hosted in cloud production environment. After this session we again parted for  a small tea break.

                   After tea break, Jeen Shene Stanislaus gave  a presentation on “Tuning Tools in SQL Server 2008”. She demonstrated various best practices which helps in increased database performance. She also demonstrated usage of various tools within SQL server 2008 for monitoring performance.

                    After Jeen’s session, It was Praseed Pai’s turn. His topic was “Mixed Mode Windows development using C# and C++”. However due to shortage of time and since he believed that he couldn’t do justice to his the original topic in half an hour, He decided to cover a small topic related to invoking native dlls created in C++ from C#.

                After Praseed’s session, Time had come  for the much awaited “Office 2010 Launch”. Presentation was done by Vijay. Vijay again rocked on stage ;). He used a fifa world cup based scenario and explained how new office 2010 features can boost our productivity. With that, the technical sessions came to an end.

                 Sreejumon started off with the Closing Ceremony and price distribution followed. There was a lucky draw. Feedback form was also collected from all participants, Which will help us to analyze and improve our activities. The developer contests and blogging contests were extended until next event. Office 2010 evaluation DVDs were also distributed to the participants.  So with that DevCon 2010 came to an end.

Conclusion

                   Overall, DevCon 2010 was a wonderful event from a participant’s perspective. Even though participation did not come to an expected level due to which we had to cut short some sessions, There was a lot of takeaways from the sessions. Also I got  a chance to volunteer the event and work with core K-Mug team which was another great experience. Also made a lot of contacts and yes the impact will last beyond the planned 2 days at DevCon for sure !!!

                   After the event the K-mug core team along with speakers gathered for  a yummy dinner and the next day we had a great outing. I’m planning to write about the details as another entry and will publish soon.

Pictures: Courtesy of msigeek

• Scenario
• Interpreting the error
• Finding the root cause
• About this SQL Server feature
• Solution
• Conclusion

Scenario

You are very likely to run into this error if you are a beginner with SQL Server 2008. You could be working with SQL Server Management Studio and trying to do any of the following actions

• Adding a new column to the middle of the table
• Dropping a column
• Changing column nullability
• Changing the order of the columns
• Changing the data type of a column

Suddenly SQL Server throws this error at you

“Saving changes is not permitted. The change 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.”

And you might be wondering what on earth you did that prevents you from just altering a table which might actually be created by you !!!

Interpreting the error

OK. So let’s try to understand what this error message is trying to say to us. It says that the changes that we are attempting requires the table to be dropped and recreated. So either the table that we are attempting to change can’t be re-created or you have enabled some option to prevent saving changes to a table that requires the table to be re-created.
Here the first case cannot be true, because if we created a table, we should be able to drop and re-create it. So what about the second possibility? You may not remember enabling any option like that. What if by default SQL Server installation enables that option? Let’s find out.

Finding Root Cause

So let’s check the option that was mentioned above. To change this option, on the Tools menu, click Options, expand Designers, and then click Table and Database Designers. There we can see the Prevent saving changes that require the table to be re-created check box as selected.

So we have identified the root cause of this error message.
By default SQL Server installation enables the option to Prevent saving changes that require table to be re-created.
Now what? If you disable the option what would happen? Of course this error message may disappear. But is there any side effects ?
In order to answer this question, We need to find out what this option is for.
So Let’s find it out.

About this SQL Server feature

Here’s Microsoft’s word about this issue. (From MSDN)

Solution

Now that we have found out the root cause and what this option is for, our recommended solution would be to script out the changes to a SQL file and execute them, or to simply write out our own T-SQL to make the changes. Although the other workaround will work it is not recommended (At least not as a permanent solution).

Conclusion

We have seen one of the common error messages that occurs in SQL Server 2008 while we try to make changes to table structures. We have interpreted the error message, found out the root cause and understood about this feature in SQL Server. We have found out the recommended solution for this problem and also looked into another workaround which works but is not recommended.
So that’s all for now, Guys.
Thanks for reading the article.
Do post your Comments, Suggestions and Views.
Have a nice day and happy programming !!!