http://msdn.microsoft.com/de-de/library/ms181007%28v=sql.90%29.aspx
sp_configure 'show advanced options', 1; GO RECONFIGURE WITH OVERRIDE; GO sp_configure 'max degree of parallelism', 1; GO RECONFIGURE WITH OVERRIDE; GO
SharePoint 2007 and SharePoint 2010 experience
sp_configure 'show advanced options', 1; GO RECONFIGURE WITH OVERRIDE; GO sp_configure 'max degree of parallelism', 1; GO RECONFIGURE WITH OVERRIDE; GO
Name | Title | LocaleId | |
GLOBAL#0 | Global template | 1033 | |
STS#0 | Team Site | 1033 | |
STS#1 | Blank Site | 1033 | |
STS#2 | Document Workspace | 1033 | |
MPS#0 | Basic Meeting Workspace | 1033 | |
MPS#1 | Blank Meeting Workspace | 1033 | |
MPS#2 | Decision Meeting Workspace | 1033 | |
MPS#3 | Social Meeting Workspace | 1033 | |
MPS#4 | Multipage Meeting Workspace | 1033 | |
CENTRALADMIN#0 | Central Admin Site | 1033 | |
WIKI#0 | Wiki Site | 1033 | |
BLOG#0 | Blog | 1033 | |
SGS#0 | Group Work Site | 1033 | |
TENANTADMIN#0 | Tenant Admin Site | 1033 | |
APP#0 | App Template | 1033 | |
APPCATALOG#0 | App Catalog Site | 1033 | |
ACCSRV#0 | Access Services Site | 1033 | |
ACCSVC#0 | Access Services Site Internal | 1033 | |
ACCSVC#1 | Access Services Site | 1033 | |
BDR#0 | Document Center | 1033 | |
DEV#0 | Developer Site | 1033 | |
DOCMARKETPLACESITE#0 | Academic Library | 1033 | |
EDISC#0 | Discovery Center | 1033 | |
EDISC#1 | Discovery Case | 1033 | |
OFFILE#0 | (obsolete) Records Center | 1033 | |
OFFILE#1 | Records Center | 1033 | |
OSRV#0 | Shared Services Administration Site | 1033 | |
PPSMASite#0 | PerformancePoint | 1033 | |
BICenterSite#0 | Business Intelligence Center | 1033 | |
SPS#0 | SharePoint Portal Server Site | 1033 | |
SPSPERS#0 | SharePoint Portal Server Personal Space | 1033 | |
SPSPERS#2 | Storage And Social SharePoint Portal ... | 1033 | |
SPSPERS#3 | Storage Only SharePoint Portal Server… | 1033 | |
SPSPERS#4 | Social Only SharePoint Portal Server … | 1033 | |
SPSPERS#5 | Empty SharePoint Portal Server Person… | 1033 | |
SPSMSITE#0 | Personalization Site | 1033 | |
SPSTOC#0 | Contents area Template | 1033 | |
SPSTOPIC#0 | Topic area template | 1033 | |
SPSNEWS#0 | News Site | 1033 | |
CMSPUBLISHING#0 | Publishing Site | 1033 | |
BLANKINTERNET#0 | Publishing Site | 1033 | |
BLANKINTERNET#1 | Press Releases Site | 1033 | |
BLANKINTERNET#2 | Publishing Site with Workflow | 1033 | |
SPSNHOME#0 | News Site | 1033 | |
SPSSITES#0 | Site Directory | 1033 | |
SPSCOMMU#0 | Community area template | 1033 | |
SPSREPORTCENTER#0 | Report Center | 1033 | |
SPSPORTAL#0 | Collaboration Portal | 1033 | |
SRCHCEN#0 | Enterprise Search Center | 1033 | |
PROFILES#0 | Profiles | 1033 | |
BLANKINTERNETCONT... | Publishing Portal | 1033 | |
SPSMSITEHOST#0 | My Site Host | 1033 | |
ENTERWIKI#0 | Enterprise Wiki | 1033 | |
PROJECTSITE#0 | Project Site | 1033 | |
PRODUCTCATALOG#0 | Product Catalog | 1033 | |
COMMUNITY#0 | Community Site | 1033 | |
COMMUNITYPORTAL#0 | Community Portal | 1033 | |
SRCHCENTERLITE#0 | Basic Search Center | 1033 | |
SRCHCENTERLITE#1 | Basic Search Center | 1033 | |
visprus#0 | Visio Process Repository | 1033 | |
Templates available in the 14 mode |
|||
Name | Title | LocaleId | |
GLOBAL#0 | Global template | 1033 | |
STS#0 | Team Site | 1033 | |
STS#1 | Blank Site | 1033 | |
STS#2 | Document Workspace | 1033 | |
MPS#0 | Basic Meeting Workspace | 1033 | |
MPS#1 | Blank Meeting Workspace | 1033 | |
MPS#2 | Decision Meeting Workspace | 1033 | |
MPS#3 | Social Meeting Workspace | 1033 | |
MPS#4 | Multipage Meeting Workspace | 1033 | |
CENTRALADMIN#0 | Central Admin Site | 1033 | |
WIKI#0 | Wiki Site | 1033 | |
BLOG#0 | Blog | 1033 | |
SGS#0 | Group Work Site | 1033 | |
TENANTADMIN#0 | Tenant Admin Site | 1033 | |
ACCSRV#0 | Access Services Site | 1033 | |
ACCSRV#1 | Assets Web Database | 1033 | |
ACCSRV#3 | Charitable Contributions Web Database | 1033 | |
ACCSRV#4 | Contacts Web Database | 1033 | |
ACCSRV#6 | Issues Web Database | 1033 | |
ACCSRV#5 | Projects Web Database | 1033 | |
BDR#0 | Document Center | 1033 | |
OFFILE#0 | (obsolete) Records Center | 1033 | |
OFFILE#1 | Records Center | 1033 | |
OSRV#0 | Shared Services Administration Site | 1033 | |
PPSMASite#0 | PerformancePoint | 1033 | |
BICenterSite#0 | Business Intelligence Center | 1033 | |
SPS#0 | SharePoint Portal Server Site | 1033 | |
SPSPERS#0 | SharePoint Portal Server Personal Space | 1033 | |
SPSMSITE#0 | Personalization Site | 1033 | |
SPSTOC#0 | Contents area Template | 1033 | |
SPSTOPIC#0 | Topic area template | 1033 | |
SPSNEWS#0 | News Site | 1033 | |
CMSPUBLISHING#0 | Publishing Site | 1033 | |
BLANKINTERNET#0 | Publishing Site | 1033 | |
BLANKINTERNET#1 | Press Releases Site | 1033 | |
BLANKINTERNET#2 | Publishing Site with Workflow | 1033 | |
SPSNHOME#0 | News Site | 1033 | |
SPSSITES#0 | Site Directory | 1033 | |
SPSCOMMU#0 | Community area template | 1033 | |
SPSREPORTCENTER#0 | Report Center | 1033 | |
SPSPORTAL#0 | Collaboration Portal | 1033 | |
SRCHCEN#0 | Enterprise Search Center | 1033 | |
PROFILES#0 | Profiles | 1033 | |
BLANKINTERNETCONT… | Publishing Portal | 1033 | |
SPSMSITEHOST#0 | My Site Host | 1033 | |
ENTERWIKI#0 | Enterprise Wiki | 1033 | |
SRCHCENTERLITE#0 | Basic Search Center | 1033 | |
SRCHCENTERLITE#1 | Basic Search Center | 1033 | |
SRCHCENTERFAST#0 | FAST Search Center | 1033 | |
visprus#0 | Visio Process Repository | 1033 |
List of all checked out files for an web applications:
SELECT
sites.FullUrl AS SiteURL, tp_DirName AS Directory, tp_LeafName AS Document, [tp_CheckoutUserId] AS UserID
FROM
[cms-roche.dev].[dbo].[AllUserData]
INNER JOIN
[cms-roche.dev].dbo.[Sites] on sites.id=alluserdata.tp_SiteId
WHERE
[tp_CheckoutUserId]<>0
List of all activated Features for a web applciation:
SELECT
sites.FullUrl AS SiteCollection, Webs.FullUrl AS Site, Features.FeatureId
FROM
[cms-roche.dev].[dbo].[Features]
INNER JOIN
[cms-roche.dev].dbo.Sites ON Features.SiteId=sites.Id
INNER JOIN
[cms-roche.dev].dbo.Webs ON Features.WebId=Webs.Id
WHERE
Features.FeatureId='00BFEA71-3A1D-41D3-A0EE-651D11570120'
With SharePoint Designer 2010 it is possible to hide a list.
Just select the list an enable hidden
If you want to hide a list please uncheck "Display this ilist on the Quick Launch" otherwise you can not hide the list
After saving this works realy fine. You also would not see the list in SharePoint Designer again.
You can if you know the URL browse to the list and work with this list, but you can not configure it in SharePoint Designer.
There is a way to make the hidden list available again.
Select in SharePoint Designer in "All Files"/Lists with a right click the hidden list.
Then choose Properties
Now you can change all settings in SharePoint Designer and also change the hidden attribute