Friday, December 27, 2013

Invalid characters in SharePoint naming conventions

This article lists the characters that you cannot use in the following names in Microsoft SharePoint:Site namesFolder nameServer namesFile namesSite names, subsite names, or site group namesYou cannot use the following characters anywhere in a site name, in a subsite name, or in a site or Active Directory group name:-Tilde (~)Number sign (#)Percent (%)Ampersand (&)Asterisk (*)Braces ({ })Backslash (\)Colon (:)Angle brackets ([ ])Question mark (?)Slash (/)Plus sign (+)Pipe (|)Quotation mark (“)You cannot start a site name, a subsite name, or...

Configure SSL for SharePoint 2013

Access SharePoint site using custom ...

Friday, December 20, 2013

Generate script for ALTER DB column Data for all tables available in DB

Run Below query to generate script:SELECT'ALTER TABLE ' + TABLE_NAME + ' ALTER COLUMN Createdby varchar(50) ;' + 'ALTER TABLE ' + TABLE_NAME + ' ALTER COLUMN Updatedby varchar(50) ;' AS ScriptFROM INFORMATION_SCHEMA.TABLESTake care of following items:Above query generate scripts for all the tables which were created in that database, deleted tables are also included in it.If tables contains that field or not it will generate script for that table also. Manually you have to remove that table script to run the generated scripts.CreatedBy and UpdatedBy...

Thursday, December 5, 2013

How to change Default Home Page : SharePoint

I frequently get questions on changing the home page or using another page as the home page: Can I have three (or four or five or…) columns in the default home page? Do I have to use the new wiki home page in my Team Site? I want to test a new home page design, but I don’t want to lose the existing home page… (just in case you know…) How can I use a page from my wiki library as my home page?Below are four ways to set another page as your home page:...