SQLTeam.com | Weblogs | Forums

Schema change not reflecting in development box

sql2008r2

#1

I'm making changes to an ASP.NET (VB.Net) Website, for change requests that require few column addition to an existing SQL table.

Everything works fine from Visual Studio and also when the website is hosted to local IIS. However when the same is published to UAT and tested, it throws DB exception saying Invalid column (for the one which i added new).

All the environments (VS, LOCAL IIS and the UAT) are pointing to the same SQL database.

Any help to resolve this is much appreciated


#2

There is no else case to check the Invalid column error. There must be some mistaken. Please check your query and connection.

https://support.microsoft.com/en-us/kb/222664