SharePoint Cheat Sheet

Just some notes of things regarding SharePoint and SQL Server:


To see that 4gb SQL Express db, install MS SQL Server Management Studio Express and use this as the “Server Name”:



To get all users from AD written to a text file, run this on a cmd line:

ldifde -f usersindomain.txt -r “(&(objectCategory=Person)(objectClass=User))

To sync the User Information List:
C:Program FilesCommon FilesMicrosoft Sharedweb server extensions12BIN>
stsadm -o sync

Get all users from “a directory” in AD and put into a text file
L:>ldifde -f usersindomain.txt -r “(&(&(|(&(objectCategory=person)(objectSid=*)(!samAccountType:1.2.840.113556.1.4.804:=3))(&(objectCategory=person)(!objectSid=*))(&(objectCategory=group)(groupType:1.2.840.113556.1.4.804:=14)))(objectCategory=user)(displayName=*)))”

See what databases are out of sync greater than 5 days
c:…12>stsadm -o sync -listolddatabases 5

This is how I set up SSO in MOSS 2007:
1) Create a new domain service account for running SSO service.
2) Change SSO service's Identity to the new service account form Services
3) Add SSO service account as a farm administrator by using “Update farm
administrator's group” link from share point central admin.
4) Right click internet explorer shortcut select “Run As” provide the
credentials for the service account to run it. (This is a very important step
– because of some bug in MOSS i guess). open share point central admin using
this IE window.
5) Setup SSO using this IE window.
6) Remove SSO service account from farm administrator group.

The gacutil lives in C:WINDOWSMicrosoft.NETFrameworkv1.1.4322


SQL Version:
SELECT  SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition');

Verify pecentage of SQL Transaction Log Space Used:

Truncating the Transaction Logs (make sure you're in the db context with the dropdown):
backup log SharedServices1_DB with truncate_only;
dbcc shrinkfile (SharedServices1_DB_log, 0);