Showing posts with label update. Show all posts
Showing posts with label update. Show all posts
Sunday, March 1, 2015
How to update Linq to SQL dbml database layout in Visual Studio 2012
I have not been working with the Linq to SQL tool before and had to make some changes to an existing Visual Studio 2012 project. Some new colums were added to a database table and i needed to update the corresponding dbml file in the Visual Studio project.
How-i-fixed-it:
I found the solution here: http://stackoverflow.com/questions/1110171/how-to-update-linq-to-sql-dbml-file
Delete the modified tables from the designer, and drag them back onto the designer surface from the Database Explorer. I have found that, for this to work reliably, you have to:
a. Refresh the database schema in the Database Explorer (right-click, refresh)
b. Save the designer after deleting the tables
c. Save again after dragging the tables back.
Read more »
How-i-fixed-it:
I found the solution here: http://stackoverflow.com/questions/1110171/how-to-update-linq-to-sql-dbml-file
Delete the modified tables from the designer, and drag them back onto the designer surface from the Database Explorer. I have found that, for this to work reliably, you have to:
a. Refresh the database schema in the Database Explorer (right-click, refresh)
b. Save the designer after deleting the tables
c. Save again after dragging the tables back.
Outlook 2013 Folder Pane empty blue gone no folders after September Office Update caused by KB2817630 patch
Recently, opening my Outlook 2013, the folder pane was empty. Indeed, it looked not really to be empty. It was filled with blue color and the was some mouseover effect happening moving the pointer over it.
How-i-fixed-it:
It turned out, that the September update of Office Software can cause this issue in case a certain combination of Outook.exe and mso.dll happens. Its the KB2817630 patch causing the problem in case the August Cumulative update is NOT installed on the Computer.
Heres what the TechNet blog says:
"Due to a version incompatibility between outlook.exe and mso.dll, a mismatched reference to a data structure causes the “Minimize” button in the navigation
pane to render incorrectly, typically extremely large to the point that the navigation pane is "invisible" to the user. The issue only manifests when incompatible versions of outlook.exe and mso.dll exist on the system."
It only happes to:
Office 2013 Standard Office 2013 Professional Plus Heres a good description, how to fix it: http://blogs.technet.com/b/office_sustained_engineering/archive/2013/09/11/outlook-folder-pane-disappears-after-installing-september-2013-public-update.aspx
Where can you find the Outlook.exe and mso.dll Version Information?
Go to File -> Office Account -> Info about Outlook

Read more »
How-i-fixed-it:
It turned out, that the September update of Office Software can cause this issue in case a certain combination of Outook.exe and mso.dll happens. Its the KB2817630 patch causing the problem in case the August Cumulative update is NOT installed on the Computer.
Heres what the TechNet blog says:
"Due to a version incompatibility between outlook.exe and mso.dll, a mismatched reference to a data structure causes the “Minimize” button in the navigation
pane to render incorrectly, typically extremely large to the point that the navigation pane is "invisible" to the user. The issue only manifests when incompatible versions of outlook.exe and mso.dll exist on the system."
It only happes to:
Where can you find the Outlook.exe and mso.dll Version Information?
Go to File -> Office Account -> Info about Outlook

Saturday, February 28, 2015
How to migrate upgrade update MS SQL Server 2000 database to SQL Server 2012
I was looking for a way / description how to upgrade an existing SQL Server 2000 database to SQL Server 2012.
How i fixed it:
SQL Server 2000 database has to be upgraded to 2005/2008 first.
If found the right hints how to do it in the SQL Server Forum here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8ab5617e-0644-4434-96af-ebc04ba89f75/upgrading-from-sql-2000-to-2012-how
The procedure is described well in this document:
http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf
It says (page 241), that i have to first upgrade the database from 2000 to 2005/2008 and then to 2012.
Read more »
How i fixed it:
SQL Server 2000 database has to be upgraded to 2005/2008 first.
If found the right hints how to do it in the SQL Server Forum here: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8ab5617e-0644-4434-96af-ebc04ba89f75/upgrading-from-sql-2000-to-2012-how
The procedure is described well in this document:
http://download.microsoft.com/download/9/5/3/9533501A-6F3E-4D03-A6A3-359AF6A79877/SQL_Server_2012_Upgrade_Technical_Reference_Guide_White_Paper.pdf
It says (page 241), that i have to first upgrade the database from 2000 to 2005/2008 and then to 2012.
Subscribe to:
Posts (Atom)