admin on November 19th, 2011

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 [...]

Continue reading about What is SharePoint?

admin on November 4th, 2011

In this post i am trying to explain, how we can customise SharePoitn 2010 webparts into different styles and colors. Step 1: Add Content Editor Web Part to page

Continue reading about SharePoint 2010 Web Parts Customization

I got this error when creating tables from one datase to another SQL Server database today. How to solve it: 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.  [...]

Continue reading about Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS”

admin on November 1st, 2011

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 [...]

Continue reading about Save (Not Permitted) Dialog Box

admin on November 1st, 2011

​You need to make both sides of a where condition, the same. I.E. … where JSG_Transactions.dbo.JSG_students.student_id COLLATE SQL_Latin1_General_CP1_CI_AS = convert(varchar(12),src.stu_code) COLLATE SQL_Latin1_General_CP1_CI_AS This forces them to be the same, and will do the comparison without winging.

Continue reading about Resolving SQL_Latin1_General_CP1_CI_AS errors