SharePoint: RegistrationId List Template Type IDs

RegistrationId List Template Type IDs

Updated again and again… (4/28/14)  This time with SharePoint 2013 additions to the list and a PowerShell script to find them.

Updated yet again again! (1/12/10)  This time with SharePoint 2010 additions.

Updated yet again! (1/18/09) When I get a chance I'll add one more column to indicate if the list is user created, "built-in" or hidden.

---------------------------------------------------------

Below is a list of RegistrationIDs for use with API code and CustomAction Features (for user created list types) and any other list types I have found.

In this article you will find:

• A table of all of the codes I have found.
• A C# routine to dump the standard enumeration of SPListTemplateTypes.
• A PowerShell script to dump the standard enumeration of SPListTemplateTypes.

For more info on CustomAction see: http://msdn.microsoft.com/en-us/library/ms460194.aspx

For a list of the CustomActions Rights values see: http://msdn.microsoft.com/en-us/library/microsoft.sharepoint.spbasepermissions.aspx

 

The Table

“ “ = WSS 3.0, "M" = MOSS 2007 only list type, "E" = MOSS 2007 Enterprise, 2010 = 2010!

0 = list, 1 = library, (4 used for surveys only???)

Fourth column contains notes, names as displayed in SharePoint or in the SQL content database and best guesses ;-)

“not in SPListTemplateType”: Most, but not all of the IDs are in an API enumeration named SPListTemplateType

-1	InvalidType			(not used)
100	GenericList	0		(see note below) Also used for "Import Spreadsheet" Also: (and I'm sure more...) Relationships List Reusable Content Quick Deploy Items Variation Labels Long Running Operation Status Notification List Reporting Metadata Cache Profiles Content and Structure Reports Reporting Metadata Suggested Content Browser Locations From Central Admin: Content Deployment Jobs Content Deployment Paths From Central Admin 2010: Job Reports Reporting Metadata
101	DocumentLibrary	1		all kinds of libraries: From 2010: cache Customized Reports Form Templates Reporting Templates Shared Documents Site Assets Style Library
102	Survey	4
103	Links	0
104	Announcements	0
105	Contacts	0
106	Events	0		Calendar
107	Tasks	0		Task lists in general, including “Workflow tasks”
108	DiscussionBoard	0		Example: “Team Discussion”
109	PictureLibrary	1
110	DataSources	1		(fpdatasources = FrontPage Data Sources???)
111	WebTemplateCatalog	1		"Site Template Gallery"
112	UserInformation	0		"User Information List" (all people)
113	WebPartCatalog	1		"Web Part Gallery"
114	ListTemplateCatalog	1		"List Template Gallery"
115	XMLForm	1		"Form Library" InfoPath Forms Library
116	MasterPageCatalog	1		"Master Page Gallery"
117	NoCodeWorkflows	1		"Workflows"
118	WorkflowProcess
119	WebPageLibrary	1		"Wiki Library" (also “Site Pages” in 2010)
120	CustomGrid	0		"Custom List in Datasheet View"
121	SolutionCatalog	0	2010	“Solution Gallery”
122	NoCodePublic	0	2010	No Code Public Workflows
123	ThemeCatalog	0	2010	“Theme Gallery”
124	DesignCatalog		2013
125	AppDataCatalog		2013
130	DataConnectionLibrary	1	M	"Data Connection Library"
140	WorkflowHistory	0		"Workflow History"  (“Macros” in 2010’s CharitableContributions template)
150	GanttTasks	0		"Project Tasks" task list
151	HelpLibrary			Product Help (Central Admin only?)
160	AccessRequest	0	2013
171	TasksWithTimelineAndHierarchy	0	2013
175	MaintenanceLogs		2013
200	Meetings	0		Meeting templates - "Meeting Series"
201	Agenda	0		Meeting templates - "Agenda"
202	MeetingUser	0		Meeting templates - "Attendees"
204	Decision			Meeting templates
207	MeetingObjective	0		Meeting templates - "Objectives"
210	TextBox	0		Meeting templates - "Directions" ("Use this list to insert custom text into your meeting.")
211	ThingsToBring	0		Meeting templates - "Things To Bring"
212	HomePageLibrary	1		Meeting templates - "Workspace Pages"
300	Sites	0	M	Sites list in Publishing templates (not in SPListTemplateType)
301	Posts	0		Used in blogs (also appears to be used for Search tabs)
302	Comments	0		Used in blogs
303	Categories	0		Used in blogs
398		0	2010	Access Services Application Log
399		0	2010	Access Services System Objects
402	Facility	0	2010	Resources  “Use the Resources list to document shared assets, such as cameras and vehicles. Users can reserve and track listed resources in Group Calendar.” (used in the new Group Work Site template)
403	Whereabouts	0	2010	Whereabouts   “Use this list to quickly and easily track the location of individuals throughout the day.” (used in the new Group Work Site template)
404	CallTrack	0	2010	Phone Call Memo  (used in the new Group Work Site template)
405	Circulation	0	2010	Circulations “Use this list to inform team members and request confirmation stamps.”  (used in the new Group Work Site template)
420	Timecard	0	2010
421	Holidays	0	2010
432		0	E	"Sample KPIs" (not in SPListTemplateType)
433		1	E	"Reports Library"(not in SPListTemplateType)
434		1	E	"Reference Library"(not in SPListTemplateType)
499	IMEDic	0	2010	IME Dictionary (Input Method Editor: http://office.microsoft.com/en-us/powerpoint/HP030900551033.aspx)
544			2013	Micro Feed / Published Feed (also 2010?)
600	ExternalList	0	2010	External List
700	MySiteDocumentLibrary		2013
850	Pages	1	M	Used with publishing templates (thanks to Anders Jacobsen for this one) (not in SPListTemplateType)
851		1	M, 2010	“Images”, “Site Collection Images”  “This system library was created by the Publishing feature to store images that are used on pages in this site.” (not in SPListTemplateType)  Also: “Asset Libary” in 2010
1100	IssueTracking	0		"Issue Tracking" task list
1200	AdminTasks	0		used in Central Administration
1220	HealthRules	0	2010	used in Central Administration
1221	HealthReports	0	2010	used in Central Administration
1230	DeveloperSiteDraftApps	1	2013	Draft Apps library in Developer Site
1300	Translation Management Library	1	M	(thanks to Dennis for this one) (not in SPListTemplateType)
1301	Languages & Translations	0	M	"Translators" Created with a 1300 (thanks to Dennis for this one) (not in SPListTemplateType)
2100		1	M	PowerPoint Slide Library (not in SPListTemplateType)
10102	Converted Forms	1		"List of user browser-enabled form templates on this site collection" (not in SPListTemplateType)

 

Note: 100 is used for any custom listed create from Site Actions -> Create -> Custom List. If you created and deployed the custom lists using a SharePoint Feature then the RegistrationID is the same as the list "Type" ID you used in your list's feature manifest file. Here is some more info: http://sharepointinsight.com/blog/Lists/Posts/Post.aspx?ID=33 Please let me know if there are more IDs for this list? For example: 203?

 

Want to see the IDs used in your site collection?    

Note that direct queries of the SharePoint content databases is never a good practice and my invalidate your support agreements! Try the following only on a test or dev server.

USE WSS_Content (database for your application)     
SELECT tp_Title, tp_BaseType, tp_ServerTemplate, tp_Description     
FROM AllLists     
ORDER BY tp_ServerTemplate, tp_Title

 

Want to see all of the IDs listed in the API enumerations using C#?

Create a Console Application and set a reference to Microsoft.SharePoint for your version (12, 14, etc).

using System;

using Microsoft.SharePoint;

namespace ConsoleApplication1

{

  class Program

  {

    static void Main(string[] args)

    {

      int i = 0;

      foreach (string enumName in Enum.GetNames(typeof(SPListTemplateType)))

      {

        i++;

        Console.Write(i);

        Console.Write(String.Format(": {0,-23} ", enumName));

        Console.Write((int)(Enum.Parse(typeof(SPListTemplateType), enumName)));

        Console.WriteLine();

      }

      Console.ReadLine();

    }

  }

}

 

Want to see all of the IDs listed in the API enumerations using PowerShell?

PS C:\> $SPtt = [Microsoft.SharePoint.SPListTemplateType]
PS C:\> [System.Enum]::GetNames($SPtt) |  select {[int][System.Enum]::Parse($SPtt, $_)}, {$_} 

.

SharePoint: Adding Advanced Search and the All Sites Scope to top level sites

Scenario: You just created a new top level site, most likely using "/sites/" and you don't have "Advanced Search" or "All Sites" in the search scope dropdown. You do have both of these available on other sites. Or, you've added custom Search Scopes and they don't show up in the Scopes dropdown. Here's what I've seen:

• If you create a top level site based on a Publishing template (and search is properly configured) you will find "Advanced Search" or "All Sites" in the search scope dropdown.
• If you create a sub-site below a Publishing template site you will find "Advanced Search" or "All Sites" in the search scope dropdown and everybody is happy.
• If you create a top level site based on Team Site, or other non-Publishing site, you will only find a basic search box with only "This Site" and "This List" in the scope dropdown.

You could just tell your users to go to the Publish site and do their searches there, or...

Try this:

Note: if you try this and it works, or fails, please leave me a comment below with your results. Somehow it seems to be too simple! Thanks!

• Make sure you have search properly configured. I.e. Advanced Search and the Scope dropdowns are working fine from other sites.
• Make sure you have a Publishing top level site (with a Search Center site)
• Make sure your top level "/sites/" site is using the same Shared Service Provider (SSP). If your site is hosted on the same server as the Publishing site, then this is the default.
• Go to the "/sites/" site and then go to Site Actions -> Site Settings -> Site Collection Administration -> Search settings
• If your root site is a Publishing site with a Search Center then enter: "/SearchCenter/Pages" else the full path to the Publish search center: "http://www.litwareinc.com/SearchCenter/Pages" or create your own search center site and enter that path: "MySearchResults"
• Now go back to the home page of your "/sites/" site and see if you now have Advanced Search and the longer list of search scopes.
• Do a test search for something unique on your "/sites/" site.
• Note that if the above works, you will be redirected to the Search Results page of your Publishing site. This may confuse your users as they may not know how to get back to your site! To fix this, just create a sub-site below your site based on the Search Center template and enter this path in Search Settings. (or you could even create a Web Part Page and the Search web parts to build your own search page!

And just to wrap up this topic... here's some things I been told / read that don't seem to be true:

• You must setup Site Actions -> Site Settings -> Portal Site Connection (This seem to just add a starting point to the crumb trail at the top of the page)
• You must turn on the Publishing Features for the site. (I have not found any reason to related to search)

Book Reviews

My students are always asking about book recommendations. I'm a bit hesitant to make recommendations as often a good book for one person is useless to another, and I'm a tough book customer and way too critical. Technology books are expensive and have a short life and I only buy those that have something special.

Here's what I look for in a book:

• Something that I can't find on the web. This usually means the book must be a complete, detailed and an ongoing reference. In contrast the web is full of tiny fragments on information (blogs, etc) and mind grinding endless documentation (MSDN for example).
• Full of stuff I can use today, and tomorrow.
• Examples that are complete and work.
• Not fluff, marking material or a meandering conversation.

Two excellent examples are:

• "Microsoft® Office SharePoint® Server 2007 Administrator's Companion" by Bill English
• Any of the "Inside SQL Server" books by Kalen Delaney such as "Inside Microsoft SQL Server 2000"

So here we go...Book review #1: Professional SharePoint 2007 Development (Programmer to Programmer)
more to come...

I have just not had time to write the book reviews I wanted to. So for now, here's a list of books that I have purchased and read, and highly recommend...


InfoPath Books:

For InfoPath books see here: http://techtrainingnotes.blogspot.com/2007/11/infopath.html

SharePoint Developer Books:

The best book for those getting started is "Inside Microsoft Windows SharePoint Services 3.0". The core framework for both WSS and MOSS is the same, so this book is the starting point.  I have not seen it yet (it's not out at the time of this note), but there's a 2010 version in the works...



SharePoint Administrator Books:
It's been around for a while, but if you are looking for the best complete book on MOSS then consider:


SharePoint Excel Services Books:
It may sound "Basic" but the best book I have seen on Excel Services is "Beginning Excel Services".

SharePoint MOSS Bootcamp notes...

First of all, thanks for attending the MOSS Bootcamp. Please let me know how you did on the exam! Below of some of the links we talked about in class...

• The best single book for an overall understanding of MOSS: Microsoft® Office SharePoint® Server 2007 Administrator's Companion. 1150 pages, and includes a CD-ROM with a full searchable copy of the book.
• Where to get or create a VPC of MOSS: http://techtrainingnotes.blogspot.com/2008/01/sharepoint-vpcs.html
• How to upgrade from SharePoint 2003 to 2007 (remember the three techniques?): http://technet2.microsoft.com/Office/en-us/library/94c49b6d-527e-4387-9557-8cfe8b55ede91033.mspx?mfr=true
• Microsoft's online documentation for SharePoint, including the free books: http://technet2.microsoft.com/Office/en-us/library/3e3b8737-c6a3-4e2c-a35f-f0095d952b781033.mspx

 

If you would like to attend a second class on SharePoint administration, consider:

MX-SPA401 Professional SharePoint Server 2007 Administration This is a four day class with about a 50% overlap with the 5061 class that the bootcamp was based on. Sometimes seeing something for a second time from a different perspective can help a lot.

 

Need more experience as a SharePoint end-user or Site Owner / Department Admin?

MS-50196 Microsoft Office SharePoint Server 2007 Power User (MOSS)

 

Want a quick introduction into what can be done with SharePoint customization? This class introduces both Visual Studio and SharePoint Designer for SharePoint customization.

MX-3530 Customizing SharePoint 2007 Applications

MA-1019 SharePoint Designer 2007 - Customizing and Branding SharePoint

 

Developers? Here are a few of out other classes that may be of interest:

MA-1038 Advanced SharePoint Training for Developers

MA-1032 Introduction to SharePoint Workflows for Developers - Microsoft SharePoint 2007: Business Processes

SharePoint VPCs

SharePoint 2010 VHDs are now available… see here: http://techtrainingnotes.blogspot.com/2010/02/sharepoint-2010-vhds-now-available.html

(the info below is for SharePoint 2007)

Update! OUCH!  Microsoft has updated the MOSS 2007 image below… and it now only works under Hyper-V, and only under Windows Server 2008 64 bit!  I cannot find a 32 bit version!

See here: http://techtrainingnotes.blogspot.com/2010/05/sharepoint-microsofts-eval-sharepoint.html

Create one!
"How to Create a MOSS 2007 VPC Image: The Whole 9 Yards"
A great step by step set of instructions by Tony Zink.
http://www.pptspaces.com/sharepointreporterblog/Lists/Posts/Post.aspx?ID=28

Create one for development work:
http://weblogs.asp.net/erobillard/archive/2007/02/23/build-a-sharepoint-development-machine.aspx

Download one!
WSS: Microsoft also has a downloadable VPC image with a full WSS install that includes Visual Studio 2008 and Visual Studio 2008 extensions for Windows SharePoint Services 3.0, v1.1:
http://www.microsoft.com/downloads/details.aspx?FamilyID=1beeac6f-2ea1-4769-9948-74a74bd604fa&displaylang=en

MOSS: Microsoft also has a downloadable VPC (now only works with Hyper-V!) image with a full MOSS Enterprise install that includes Office 2007:  
http://www.microsoft.com/downloads/details.aspx?FamilyID=67f93dcb-ada8-4db5-a47b-df17e14b2c74&DisplayLang=en
VPCs for more Microsoft products here: http://technet.microsoft.com/en-us/bb738372.aspx

The general requirements for using these VHDs are:
- A system with supported Operating Systems: Windows Server 2003 or Windows XP or Windows Vista
- Other Requirements: Personal Computer with 1.5 GHz or higher processor and at least 1 GB RAM.
- Free hard drive space as required by the VHD
- Super VGA (1024x768) video adapter/monitor
- Microsoft Virtual Server 2005 R2 software

Want to get rid of "Shutdown Event Tracker" popup you see every time you shutdown the VPC?
Here's a great article describing the feature and how to turn it off: http://www.windowsnetworking.com/articles_tutorials/Disable-Shutdown-Event-Tracker-Windows-2003.html

And here's the official article from Microsoft:
http://support.microsoft.com/kb/293814

SharePoint: SmallSearchInputBox tip

If you are looking here to find out how to get Advanced Search or custom search scopes to show up then also check here.

 

While researching the SharePoint DelegateControl I found some misleading information on the value of the sequence attribute that should be used with a custom Feature to replace the default search box (SmallSearchInputBox). Most of the blogs say that sequence should be less than 100 to make your search control be used in place of the default. Turns out that sequence must be less than 25, not 100.

I think that many of the articles on the web may have been tested on WSS, not MOSS. MOSS has it's own Features to replace the search box.

On my server these Features also override SmallSearchInputBox:

    ContentLIghtup   sequence=100
    OsearchBasicFeature   sequence=50
    OsearchEnhancedFeature   sequence=25

So any custom Feature you add needs a sequence number less than 25.

 

.

Book review: Professional SharePoint 2007 Development

I always have mixed emotions about books written by more than one author, especially when each writes their own chapter. This is one of those... Professional SharePoint 2007 Development (Programmer to Programmer) WROX ISBN: 978-0470117569 To start with, the title of the book includes the word "Development" and "Programmer to Programmer". To me that usually means coding. Several of the chapters have no or little code and are really an introduction to selected SharePoint features. That said, the chapters with code do make the book worth the price. Keep in mind that this book is not a "how to write code for SharePoint" book. It is a collection of articles from eight different authors. There is no obvious starting place to learn how to write SharePoint code. For that matter almost half of the book is really "Introduction to SharePoint". Other the other hand, the other half of the book is quite good, and I think justifies it's purchase. If you think I'm a bit negative in the review below, just remember I was looking for hardcore coding bookand was disappointed to find so much overview material. (If you want good detailed and very complete overview and admin material you should be looking at "Microsoft® Office SharePoint® Server 2007 Administrator's Companion" by Bill English) Do I recommend the book? Will I keep it in my library? Yes. Especially for the chapters written by John Holiday (11, 12, 13, 14, 15) and the last half of chapter 2. Those justify the cost of the book, and the rest is ok as filler. (my applogies to those other authors) As each chapter was written independently of the others, I guess I will need to review each chapter! (scored on a 1=bad to 5=good scale) Chapter 1: The Microsoft Application Platform and SharePoint This is just an overview of SharePoint and positioning with other Microsoft products. Coding Value? 0 General Info Value? 3 Chapter 2: MOSS 2007 Overview for Developers The first 10 some pages is just an overview, again. But, the next 20 pages are execelent! And these 20 pages have nothing to do with the title of the chapter. What are they about? Building a Virtual PC development environment! Combine this with the "Whole 9 Yards" blog article and you have everything you need to build SharePoint VPCs. Coding Value? 0 for code, but 5 for building VPCs General Info Value? 3 for the first 10 pages and 5 for the rest Chapter 3: The SharePoint User Experience An introduction to SharePoint with a small detour into coding "cross-list queries" and an introduction to using SharePoint with mobile devices. The one coding example is kind of out of place in that this is the first sample of code in the book and none of the objects have been explained yet. For that mater the author does not even mention how the code might be used or tested. I.e. custom page, web part, or whatever... Coding Value? 2 General Info Value? 3 Chapter 4: WSS v3 Platform Services This is one of the larger chapters and introduces Site Definitions, Custom Field Types, Features, Solutions and Web Parts. All of these are very important to the developer. The only complaint that I have is the large number of tables of XML elements, most likely copied from Microsoft online content. Coding Value? 1 (very little code) General Info Value? 5 (all very important topics around deployment) Chapter 5: Programming Windows SharePoint Services An decent introduction to the SharePoint object model and some Visual Studio basics. Again, way too many lists copied from Microsoft content with no additional value. Coding Value? 3 General Info Value? 3 Chapter 6: A Sample Collaboration Solution A step by step on how to create a site and lists??? The one good thing in this section is how to create a SharePoint event receiver. A better title for this chapter might have been "Creating an Event Receiver (and testing in a sample site)" Coding Value? 4 General Info Value? 3 Chapter 7: RSS, Blogs, and Wikis Yet another "Introduction to SharePoint" chapter! No code at all (except for a sample RSS XML file). Coding Value? 0 General Info Value? 1 Chapter 8: Building Personalized Solutions If you are just starting development work with SharePoint then save this chapter for later. It covers Profiles, MySites and Audiences. Coding Value? 4 General Info Value? 3 Chapter 9: Using Enterprise Search Another intro chapter with a mix of administration and development stuff. A real opportunity was missed by not spending a good amount of time on creating custom search pages. Coding Value? 0 General Info Value? 2 Chapter 10: Using the Business Data Catalog Another overview chapter. But 29 pages of raw XML listings of BDC files is a joke. (WROX must have demanded at least 700 pages for this book. It has 715.) The only real code example dumps the info from the BDC XML file. I would have like to have seen an example of a web part or ASPX page using data delivered via the BDC. Coding Value? 0 General Info Value? 1 Sounds pretty bad so far? Hang on, we are getting to the good stuff! Chapter 11: Building Document Management Solutions Chapter 12: Building Records Management Solutions Chapter 13: Building Web Content Management Solutions I listed all three of these together as they are all written by the same author and all have great content and examples. Coding Value? 5 General Info Value? 5 Chapter 14: Electronic Forms in MOSS 2007 Oops, back to basics. Almost no coding here. But as far as "basics" chapters go, this is one of the better ones and may give you some ideas (but no code to get them done). Coding Value? 0 General Info Value? 4 Chapter 15: Building Workflow Solutions This pretty decent coverage of workflows! And it's one of the larger chapters at 70 pages or so. Coding Value? 5 General Info Value? 5 Chapter 16: Business Intelligence and SharePoint Server 2007 Another overview chapter. The only code here is straight from an MSDN article. If you have not looked into Excel services, there is some good info here on what can and cannot be done with Excel. Coding Value? 0 General Info Value? 3 Appendix A: Using the Microsoft Visual Studio 2005 Extension One of the more useful chapters in the book! You may want to start with this one. If you've gotten this far... Yes, I would by the book just for the chapters written by John Holiday (11, 12, 13, 14, 15) and the last half of chapter 2.

WSS401

Links for students of Max's WSS-401 class. MSDN Webcast: Microsoft ASP.NET AJAX 1.0 and SharePoint (Level 300) Event ID: 1032340725 http://msevents.microsoft.com/CUI/WebCastEventDetails.aspx?EventID=1032340725&EventCategory=3&culture=en-US&CountryCode=US A good Forms Based Authentication set of web parts:http://weblogs.asp.net/paulballard/archive/2007/05/01/sharepoint-moss-2007-forms-based-authentication-login-registration-web-part.aspx Minimal master pages http://www.heathersolomon.com/blog/articles/BaseMasterPages.aspx CSS Chart http://www.heathersolomon.com/content/sp07cssreference.htm SharePoint Visual Studio Project and Deployment Templates http://blogs.msdn.com/gderun/archive/2008/01/11/sharepoint-visual-studio-project-and-deployment-templates.aspx Setting up Kerberos for SharePoint http://blogs.msdn.com/martinkearn/archive/2007/04/23/configuring-kerberos-for-sharepoint-2007-part-1-base-configuration-for-sharepoint.aspx U2U CAML Query Builder for SharePoint 2003 and SharePoint 2007 http://www.u2u.net/res/Tools/CamlQueryBuilder.aspx Sample application to extract XML definitions of Lists, Columns and Content Types (not fancy, just a quick example. you are on your own with this one!) http://www.microsmithinc.com/Blogstuff/SharePointXmlGetter.zip Microsoft's workflow samples: http://www.microsoft.com/downloads/details.aspx?FamilyId=2611A6FF-FD2D-4F5B-A672-C002F1C09CCD&displaylang=en WF Tutorials and Samples http://www.microsoft.com/downloads/details.aspx?familyid=C1863E23-482C-4B79-9F3C-417A92D8D1D9&displaylang=en 10 hours of hands-on labs for WF http://www.microsoft.com/downloads/details.aspx?familyid=2E575633-E357-4EE7-AAFF-34138F00E830&displaylang=en WSS SDK http://www.microsoft.com/downloads/details.aspx?familyid=05E0DD12-8394-402B-8936-A07FE8AFAFFD&displaylang=en

Renaming a Server Breaks SQL Server!

If you've not run across this one yet, you will one of these days. It's been around for a long time and is pretty easy to fix by rerunning Setup. How does your server get renamed?

• The obvious answer: you did it! You renamed the server.
• No so obvious: you installed SharePoint on a test server using local accounts and then decided to add Active Directory or join the server to a domain so you can play with all of the email features. (typical error code in the Event viewer is 17204)

Just Re-run Setup...

To fix it just rerun SQL Setup and let it repair the installation. But what about Microsoft Sql Server Embedded Edition (SSEE), the free, default and well hidden edition of SQL server that does not come with a setup program? Several Knowledgebase articles describe how to do this with a command line tool, but they never tell you enough. Here's one: http://support.microsoft.com/kb/929665 They show you this line: Msiexec CALLERID=OCSetup.exe REINSTALL=ALL REINSTALLMODE=omus /qn REBOOT=ReallySupress /l*v But they don't tell you the MSI_File_Name and it leaves out one switch. Here's one that worked for me: Msiexec /i "C:\Program Files\MSECache\wssv3\database\SSEE_10.msi" CALLERID=OCSetup.exe REINSTALL=ALL REINSTALLMODE=omus /qn REBOOT=ReallySupress /l*v c:\log.txt Note: If you are doing this to fix a SharePoint problem remember to run the SharePoint Products and Technologies Configuration Wizard to let it fix the internal database names. Some notes on SSEE:

• Does not include any management tools, but you can connect to it using SQL Server Studio (regular or Express) with this "server name": \\.\pipe\mssql$microsoft##ssee\sql\query
• It lives here: C:\WINDOWS\SYSMSI
• The databases are here by default: C:\WINDOWS\SYSMSI\SSEE\MSSQL.2005\MSSQL\Data

Which Conference or Event to Attend in 2008?

Too many choices! So little time and money... DevConnections? April 20-23 Orlando, FL 5 shows in 1! SharePoint Connections, ASP.Net Connections, SQL Server Connections, Architect Connections, Visual Studio & .Net Connections. http://www.devconnections.com/ Microsoft Office System developer conference? Feb 10-13 2008 San Jose, California https://microsoft.crgevents.com/ODC2008/ SharePoint Conference 2008 March 2-6 Seattle, Washington http://mssharepointconference.com Can't decide between Office Developer Conference 2008 vs. SharePoint Conference 2008? Check out this SharePoint Product Group blog SharePoint Information Worker Conference 2008 Feb 2-6 Nashville, TN http://sharepointsolutions.com/sharepoint-conferences/sharepoint-conference.html TechEd 2008 Orlando, FL Oh No! There are two of them this year! Tech·Ed U.S. 2008 Developers June 3-6, 2008 Tech·Ed U.S. IT Professionals June 10-13, 2008 http://www.microsoft.com/events/teched2007/default.mspx Microsoft Office Visio Conference 2008 Feburary 5-6 Redmond, WA http://www.msvisioconference.com/