Sharepoint: Site collection administrators lose their permissions
By peter.stilgoe
Sharepoint Site collection administrators lose their permissions.
An odd problem where I would login to Sharepoint with my normal Sharepoint Site Collection Administrator account & I would only have basic permissons & various OK buttons were greyed out.
This seems to be caused by having multiple jobs running against your Sharepoint databases at the same time, Sharepoint puts the site collection/database into Read Only mode.
To unlock the Sharepoint site / site collection either use Central Admin:
http://SharepointServer/_admin/sitequota.aspx
or use Stsadm:
stsadm -o -setsitelock -url http://servername/sitename/ -lock None
Using a lookup to return data from a list on a different site
By peter.stilgoe
At first glance this doesnt look possible OOTB but it is, just not very obvious!
The way to achieve this is to:
1) Create a list at say Site Collection level which contains a column with the data in you want to use on another site.
2) Now create a Lookup column at Site Collection Level which is pointing to the data from the above list that you want to use.
3) Now you can add that column, to any list, on any site, throughout the site collection.



July 11th, 2011
