Sharepoint

Useful Websites


http://technet.microsoft.com/en-us/library/ee428287.aspx



Useful STSADMIN Commands


To delete SSP –
stsadm –o deletessp –title <SSP Name> -deletedatabases -force

Add content DB –
Stsadm –o addcontentdb –url <URL> -databasename <db name> -databaseserver <sql server name>

Delete config option –
Stsadm –o deleteconfigurationobject –id <GUID>

Find GUID – tSQL
SELECT * FROM [sharepoint_config].[dbo].[Objects]where name like '<DB Name>'

GET GROUPS FROM SITE (TSQL)

SELECT Groups.Title, UserInfo.tp_Login, UserInfo.tp_Title, UserInfo.tp_Email
FROM GroupMembership INNER JOIN
Groups ON GroupMembership.GroupId = Groups.ID INNER JOIN
UserInfo ON GroupMembership.MemberId = UserInfo.tp_ID
where userinfo.tp_isactive = '1'
order by userinfo.tp_Login