How to identify the template used to create a site ..

If you see an error like this: fatalError: cocould not find webtemplate #75801 with lcid 1033.

At this time, the followingArticleThis is useful. The author lists all template IDs, cool!
Http://sharepointmadeeasy.blogspot.com/2009/01/how-to-identify-template-used-to-create.html

I use to wonder in case solution (WSP files) when deployed on the server globally
If the solution are available the sites are also made using those solution. now I had a question in my mind that how cocould I find which templates are Bening applied on the site. in case site are moved I. E server is backup is restored over a new server, creation on new configuration database, solution are removed etc
At last we end up in getting message
"Page not found 'or" Internet Explorer cocould complete this request "or" unkown error"
I created a aspx file usign the code snipet given below
Code snippet [before every tag, '--' is added, you need to remove the hyphens]
========================================================== ============================
<-- Script Type = "text/JavaScript" <-- % @ Assembly name = "Microsoft. Sharepoint, version = 12.0.0.0, culture = neutral, publickeytoken = 71e9bce111e9429c" %>
<-- % @ Page Language = "C #" masterpagefile = "~ /_ Layouts/application. Master "inherits =" Microsoft. Sharepoint. webcontrols. layoutspagebase "%>
<-- % @ Import namespace = "Microsoft. SharePoint" %>

<-- Script runat = "server">
Protected override void onload (eventargs e ){
Spsecurity. runwithelevatedprivileges (delegate ()
{
Using (spweb thisweb = This. Web)
{
Lblwebtempalte. Text = thisweb. webtemplate;
Lblwebtemplateid. Text = thisweb. webtemplateid. tostring ();
}
});
}
<--/SCRIPT>
<-- ASP: Content ID = "Main" runat = "server" contentplaceholderid = "placeholdermain">

Web template: <-- ASP: Label id = "lblwebtempalte" runat = "server"/>

Web template ID: <-- ASP: Label id = "lblwebtemplateid" runat = "server"/>
<--/ASP: content>

<-- ASP: Content ID = "pagetitle" runat = "server" contentplaceholderid = "placeholderpagetitle">
Site template information
<--/ASP: content>

<-- ASP: Content ID = "pagetitleintitlearea" runat = "server" contentplaceholderid = "placeholderpagetitleintitlearea">
Site template information
<--/ASP: content>

<--/SCRIPT>
========================================================== ==============================

 

Web template: -----> web template ID:
==================================
Absence ----> absencevacationschedule ----> 75811
Projmulti ----> budgetingtrackingmultipleprojects ----> 75819
BT ----> bugdatabase ----> 75801
Callcenter ----> 75812
Projchange ----> changerequest ----> 75818
Comproc ----> complianceprocesssupport ----> 75813
Dr ----> documentlibraryreview ----> 75803
Eventplan ----> 75814
Exreports ----> expensereimbursementapproval ----> 75815
Helpdesk ----> helpdesk ----> 75816
It ----> inventorytracking ----> 75804
Itteam ----> itteamworkspace ----> 75817
Jrim ----> jobrequisition ----> 75805
KB ----> Knowledgebase ----> 75806
Ll ----> lendinglibrary ----> 75807
Patm ----> physicalassettracking ----> 75808
Projsing ----> projecttrackingworkspace ----> 75820
RER ----> roomequipmentreservations ----> 75809
St ---> salesleadpipeline ----> 75810

List of out of the box Moss 2007 template ID information
========================================================== ======================
Name ----> web template: ----> web template ID:
==================================

Global ----> global template "----> 0
STS ----> team site, blank site, Document Workspace ----> 1
MPs ----> basic Meeting Workspace ----> 2
MPs ----> blank Meeting Workspace ----> 2
MPs ----> demo-meeting workspace ----> 2
MPs ----> social Meeting Workspace 2
MPs ----> multipage Meeting Workspace 2
Centraladmin ----> central admin site ----> 3
Wiki ----> wiki site ----> 4
BDR ----> document center ----> 7
Blog ----> blog ----> 9
SPS ----> SharePoint Portal Server site ----> 20
Spspers ----> SharePoint Portal Server personal space ----> 21
Spsmsite ----> personalization site ----> 22
Spstoc ----> contents Area Template ----> 30
Spstopic ----> topic area template ----> 31
Spsnews ----> News Area Template ----> 32
Spsnhome ----> News home template ----> 33
Maid ----> site directory Area Template ----> 34
Spscommu ----> Community Area Template ----> 36
Spsreportcenter ----> report center site "----> 38
Cmspublishing ----> publishing and team collaboration site ----> 39
Osrv ----> shared services administration site ----> 40
Spsportal ----> modify ate Intranet site ----> 47
Srchcen ----> Search center ----> 50
Profiles ----> profiles ----> 51
Blankinternetcontainer ----> Internet presence web site ----> 52
Blankinternet ----> publishing site ----> 53
Blankinternet ----> press releases site ----> 53
Blankinternet ----> publishing site ----> 53
Spsmsitehost ----> my site host ----> 54
Srchcenterlite ----> Search center lite ----> 90
PWA ----> project web access site ----> 6221
PWS ----> Project workspace ----> 6215
Offile ----> records repository ----> 1483
Offile ----> records repository ----> 14483

 
To find out how many solutions are deployed on the server we can achieve
Central Administration> operation> solution Management
We wocould be finding the list of WSP file or cab files installed

To find the solution from the configuration database to you configuration database (eg wss_config)

Go to the databases open the table DBO. Objects. You wocould be finding the list of solution in inside the tables
Note:-above steps wocould be senario specfic. Before doing any step its advisable to take a full farm back and SQL back up to be on safe side