:::: MENU ::::

SQL Hour meeting held today

  • Jan 15 / 2010
  • 0
dbDigger, IsbSSUsers, IsbSSUsers meetings

SQL Hour meeting held today

According to plan today we had IsbSSUers group meeting. Surprisingly meeting broke decided time and lot more concepts were discussed and covered in this meeting. Following SQL Server topics were covered

  • Extended properties for SQL Server objects
  • Go through basic cursor operations
  • Using cursors where they may be efficient
  • Avoiding cursors in certain conditions
  • Create basic SQL Server maintenance plans

During maintenance plan creation demo on development machine, we got error while saving maintenance plan. Error statement was
No description found
while trying to save the maintenance plan.
After some googling, the reason found was to install the original release version of Microsoft Office Visio 2003 after installation of SQL Server 2005. It is mentioned by Microsoft technical support that you may also experience this problem when you run the SQL Server Import and Export Wizard.This problem occurs because the Microsoft Office Visio 2003 Setup program incorrectly sets the registry entries for Microsoft Core XML Services (MSXML). In this case, the wrong version of the Msxml.dll file is being used when you create SSIS packages or maintenance plans.
To resolve this problem, install Microsoft Office Visio 2003 Service Pack 1 from here.
For further work around consult this MS knowledge base article.
Over all this group meeting was fantastic and provided us to learn through coordination and discussion.

Consult us to explore the Databases. Contact us