Monthly Archives - November 2011

What is SharePoint?

Sometime you are working on a technology for a long time but you still feel difficult to explain in a non-technical way or in simple words. Same case is with SharePoint, SharePoint is not simple thing. SharePoint is not a program, it is platform, it is collection of programs. Learning SharePoint is learning like MS Office. You don’t learn one product you learn whole package i.e. MS Word, PowerPoint, Excel, Access so on.

What does SharePoint do, it makes websites. For every purpose you can create a website. It is a massive website build engine. SharePoint helps to collaborate your work with other team members, not only within your organisation but also outside the organisation.

(more…)

Read more...

Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS”

I got this error when creating tables from one datase to another SQL Server database today.

How to solve it:
  1. Change to single-user mode in your database
Command to change  Single-User mode or Mutilple-User mode in sql server
database
ALTER DATABASE [Works] SET MULTI_USER WITH
NO_WAIT
ALTER DATABASE [Works] SET SINGLE_USER WITH
NO_WAIT
     2.  Change the collation of from Latin1_General_CI_AS to SQL_Latin1_General_CP1_CI_AS
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS"

SQL Server Database Properties

   3.  Drop and re-create those tables which are still using collation Latin1_General_CI_AS in their columns.
This step is necessary the table level is still sticking to the previous collation
     4.  Restore the data of those tables.
Read more...

Save (Not Permitted) Dialog Box

Save (Not Permitted) Dialog Box  SQL Server 2008 R2
The Save (Not Permitted) dialog box warns you that
saving changes is not permitted because the changes you have made require the
listed tables to be dropped and re-created.
The following actions might require a table to be re-created:
  • 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
To change this option, In sql sever management studio on the Tools menu, click Options, expand
Designers, and then click Table and
Database Designers. Select or clear the Prevent saving
changes that require the table to be re-created check box.
Read more...