feedburner

Subscribe

View Venkat Varkala's profile on LinkedIn

Deploying MOSS using DBA created databases

Labels:

When you configure MOSS using "SharePoint Products and Technologies Configuration Wizard", in the first step it creates 2 databases

  1. SharePoint_config : The configuration database - you will be able to change this name.
  2. SharePoint_AdminContent_XXXXXXXX_XXXX_XXXX_XXXX_XXXXXXXXXXXX : The Admin content database - wizard doesn't give you any option to change this name.
No one (esp. DBA's) like GUID's in database name, the only option to avoid this is by using pfconfig command line tool. You can find step by step documentation at Microsoft Technet There are some mistakes in above documentation esp in "Starting Office SharePoint Search Service".
stsadm -o osearch -action start -role -farmcontactemail -farmserviceaccount -farmservicepassword -farmcontentaccessaccount -farmcontentaccesspassword
you cannot pass "farmcontentaccessaccount" & "farmcontentaccesspassword" parameters for osearch action.

stsadm_osearch.png

Below command shoud be sufficient
stsadm -o osearch -action start -role -farmcontactemail -farmserviceaccount -farmservicepassword
It is also good idea to Use -setheadername while creating MySites & Web Application

Site Definition "SPS", is it really obsolete???

Labels:

If you look into webtempsps.xml, you will find first template

<Template Name=”SPS” ID=”20″> <Configuration ID=”0″ Title=”SharePoint Portal Server Site” Type=”0″ Hidden=”TRUE” ImageUrl=”../images/spshome.gif” Description=”This template is obsolete.”> </Configuration> </Template>

The description message “This template is obsolete.” is very misleading. Is this template really obsolete? Does that mean “\12\TEMPLATE\SiteTemplates\SPS\XML\ONET.XML” is not used for any Site Creation?

If you look into the same file webtempsps.xml, you will see another virtual template “SPSPORTAL” (probably the most used Site Definition for creating Intranet Portal)

<Template Name=”SPSPORTAL” ID=”47″> <Configuration ID=”0″ Title=”Collaboration Portal” Type=”0″ Hidden=”FALSE” ImageUrl=”/_layouts/1033/images/template_corp_intranet.png” Description=”A starter site hierarchy for an intranet divisional portal. It includes a home page, a News site, a Site Directory, a Document Center, and a Search Center with Tabs. Typically, this site has nearly as many contributors as readers and is used to host team sites.” ProvisionAssembly=”Microsoft.SharePoint.Publishing, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c” ProvisionClass=”Microsoft.SharePoint.Publishing.PortalProvisioningProvider” ProvisionData=”SiteTemplates\\WebManifest\\PortalWebManifest.xml” RootWebOnly=”TRUE” DisplayCategory=”Publishing” VisibilityFeatureDependency=”97A2485F-EF4B-401f-9167-FA4FE177C6F6″> </Configuration> </Template>

This above template is Virtual because you don’t find any folder named “SPSPORTAL” in “\12\TEMPLATE\SiteTemplates” instead this site template is driven by ProvisionData (”SiteTemplates\\WebManifest\\PortalWebManifest.xml”), this manifest file is used to create Multiple sites. If you look into “SiteTemplates\\WebManifest\\PortalWebManifest.xml” file, the very first web element points to SPS site definition.

<portal xmlns=”PortalTemplate.xsd”> <web name=”Home” siteDefinition=”SPS” displayName=”$Resources:spscore,PortalManifest_Home_DisplayName;” description=”$Resources:spscore,PortalManifest_Home_Description;”> <webs> <web name=”News” siteDefinition=”SPSNHOME” displayName=”$Resources:spscore,PortalManifest_News_DisplayName;” description=”$Resources:spscore,PortalManifest_News_Description;” /> <web name=”SiteDirectory” siteDefinition=”SPSSITES” displayName=”$Resources:spscore,PortalManifest_SiteDirectory_DisplayName;” description=”$Resources:spscore,PortalManifest_SiteDirectory_Description;” /> <web name=”SearchCenter” siteDefinition=”SRCHCEN” displayName=”$Resources:spscore,PortalManifest_SearchCenter_DisplayName;” description=”$Resources:spscore,PortalManifest_SearchCenter_Description;” /> <web name=”Docs” siteDefinition=”BDR” displayName=”$Resources:spscore,PortalManifest_DocumentCenter_DisplayName;” description=”$Resources:spscore,PortalManifest_DocumentCenter_Description;” /> </webs> </web> </portal>

To prove that Collaboration Portal actually uses SPS Site Definition to create Home Site

  1. lets rename the “SPS” to “SPS1″ in webtempsps.xml, your template should like

    <Template Name=”SPS1″ ID=”20″> <Configuration ID=”0″ Title=”SharePoint Portal Server Site” Type=”0″ Hidden=”TRUE” ImageUrl=”../images/spshome.gif” Description=”This template is obsolete.”> </Configuration> </Template>

  2. run IISRESET
  3. Create a Site Collection by selecting “Collaboration Portal” Template, do you get an error???

Note: Make sure that you rename the Template name back to “SPS”.

Awesome Video of Kite Flying

Labels:

I love flying kites, probably I have never seen anyone flying kites like this.

DocumentTemplate Element (ContentType) Vs. DocumentTemplate Element (Site)

Labels:

DocumentTemplate Element could be very confusing, they have totally different set of attributes based on where you are using (Site Definition ONET.XML or Feature). DocumentTemplate Element (Site)


DocumentTemplate Element (ContentType)
I find creating new Document Content Type very easy using "Feature" feature instead of messing with ONET.xml Click here for more info on creating document content types using feature

Understanding webtemp*.xml

Labels:

Probably the best way to understand the concept of webtemp*.xml is to create couple of custom site definitions. Recently I stumbled upon a great blog entry from Bill Baer, I wish I had access to this information last year, when I was playing with Site definitions. Below is the excerpt from http://blogs.technet.com/wbaer/archive/2007/03/25/understanding-webtemp-xml.aspx

WEBTEMP.xml
Products: Microsoft Office SharePoint Server 2007/Windows SharePoint Services 3.0
Includes: Team Site, Blank Site, Document Workspace, Basic Meeting Workspace, Blank Meeting Workspace, Decision Meeting Workspace, Social Meeting Workspace, Multipage Meeting Workspace, Central Admin Site, Wiki Site, and Blog templates.
webtempsrch.xml
Products: Microsoft Office SharePoint Server 2007
Includes: Search Center template.
webtempsps.xml
Products: Microsoft Office SharePoint Server 2007 Includes: SharePoint Portal Server Site, SharePoint Portal Server Personal Space, Personalization Site, Contents area Template, Topic area Template, News Site, Publishing Site, Press Releases Site, Publishing Site with Workflow, Site Directory, Community area Template, Report Center, Collaboration Portal, Search Center with Tabs, Profiles, Publishing Portal, My Site Host templates.
webtempoffile.xml
Products: Microsoft Office SharePoint Server 2007 Includes: Records Center template.
webtempbdr..xml
Products: Microsoft Office SharePoint Server 2007 Includes: Document Center template.
webtemposrv.xml
Products: Microsoft Office SharePoint Server 2007 Includes: Shared Services Administration Site template.
Configuration Attributes:
  • </font> Template title text displayed in the Template Selection user interface.</li> <li><font color="#00688b"><Description></font> Description of the purpose and features of the requested template displayed in the Template Selection user interface.</li> <li><font color="#00688b"><ImageUrl></font> Provides the virtual path to the preview image displayed in the Template Selection user interface.</li> <li><font color="#00688b"><DisplayCategory></font> Defines the category where the template should be made available for selection in the Template Selection user interface.</li> <li><font color="#00688b"><RootWebOnly></font> Defines the usage scenario in which this template can be applied.</li> <li><font color="#00688b"><ProvisionAssembly></font> Provides the fundamental publishing infrastructure in <strong>Microsoft Office SharePoint Server 2007</strong>.</li> <li><font color="#00688b"><ProvisionClass></font> Defines the class associated with the <ProvisionAssembly> attribute.</li> <li><font color="#00688b"><ProvisionData></font> Provides the virtual path to the associated Web manifest (%commonprogramfiles%\Microsoft Shared\Web Server Extensions\12\TEMPLATE\SiteTemplates\WebManifest\portalwebmanifest.xml)</li> <li><font color="#00688b"><VisibilityFeatureDependency></font> Feature dependency associated with the template that provides its visibility.</li> </ul> </blockquote> </p> <div style='clear: both;'></div> </div> <div class='metadata1'> <p class='metadata'><small> <span> <abbr class='post_date' title='Wednesday, June 06, 2007'>Wednesday, June 06, 2007</abbr></span> | <span class='post-icons'> <a href='http://www.blogger.com/comment.g?blogID=7408302771999513124&postID=9028617557396339974' onclick=''>0 Comments</a> </span></small> </p> <p class='post-footer-line post-footer-line-2'></p> <p class='post-footer-line post-footer-line-3'></p> </div> </div> <div class='post hentry'> <script type='text/javascript'> var timestamp = "Tuesday, June 05, 2007"; if (timestamp != '') { var timesplit = timestamp.split(","); var date_yyyy = timesplit[2]; var timesplit = timesplit[1].split(" "); var date_dd = timesplit[2]; var date_mmm = timesplit[1].substring(0, 3); } </script> <div class='the_date'> <div class='date_m'><script type='text/javascript'>document.write(date_mmm);</script></div> <div class='date_d'><script type='text/javascript'>document.write(date_dd);</script></div> </div> <a name='1473549750956773373'></a> <h2> <a href='http://www.venkat.org/2007/06/reporting-services-add-in-reportserver.html'>Reporting Services Add-in : ReportServer Feature in Application Management Site Collection</a> </h2> <div class='post-header-line-1'> <span class='post-author vcard'> Posted by <span class='fn'>Venkat Varkala</span> </span> <span class='files'> Labels: <a href='http://www.venkat.org/search/label/SharePoint' rel='tag'>SharePoint</a> </span> </div> <div class='entry'> <p>After debugging multiple errors during installation & errors trace left in event logs, I still find "Reporting Services" section missing in my Application Management. There is one more place to look for error logs "in %temp% directory", reporting services logs information to a log file in the %temp% folder for the user who is installed the Reporting Services Add-in, the file name is RS_SP_<number>.log. Looks like there is an error activating the ReportServer Feature in the Central Administration. <p align="center"><font color="#ff0000">******* User does not have permission to add feature to site collection: http://machinename:8080</font></p> This can be resolved by activating the ReportServer Feature manually through command line (stsadm) or else through site settings <ol> <li>Go to SharePoint 3.0 Central Administration.</li> <li>Select Site Actions -> Site Settings</li> <li>Click Site Collection Features</li> <li>Activate Report Server Integration Feature in the list</li> </ol> </p> <div style='clear: both;'></div> </div> <div class='metadata1'> <p class='metadata'><small> <span> <abbr class='post_date' title='Tuesday, June 05, 2007'>Tuesday, June 05, 2007</abbr></span> | <span class='post-icons'> <a href='http://www.blogger.com/comment.g?blogID=7408302771999513124&postID=1473549750956773373' onclick=''>0 Comments</a> </span></small> </p> <p class='post-footer-line post-footer-line-2'></p> <p class='post-footer-line post-footer-line-3'></p> </div> </div> <div class='post hentry'> <script type='text/javascript'> var timestamp = "Tuesday, June 05, 2007"; if (timestamp != '') { var timesplit = timestamp.split(","); var date_yyyy = timesplit[2]; var timesplit = timesplit[1].split(" "); var date_dd = timesplit[2]; var date_mmm = timesplit[1].substring(0, 3); } </script> <div class='the_date'> <div class='date_m'><script type='text/javascript'>document.write(date_mmm);</script></div> <div class='date_d'><script type='text/javascript'>document.write(date_dd);</script></div> </div> <a name='2881365759173586271'></a> <h2> <a href='http://www.venkat.org/2007/06/reporting-services-add-in-installation.html'>Reporting Services Add-in Installation Error: The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID</a> </h2> <div class='post-header-line-1'> <span class='post-author vcard'> Posted by <span class='fn'>Venkat Varkala</span> </span> <span class='files'> Labels: <a href='http://www.venkat.org/search/label/SharePoint' rel='tag'>SharePoint</a> </span> </div> <div class='entry'> <p>Reporting Services Add-in is such a pain it hangs on at "removing backup files" screen for hours, never kill that process because that is a wrong message, its not such removing backup files its doing much more than that, if you kill that process everything will seem fine except that any SQL reports won't be generated. Recently I found out another issue with this add on, the installation will fine with no errors and you will get "Installation Complete" screen but it will leave below errors in Event logs and the Reporting Services section won't appear in the Application Management (Central Administration). <font size="1"><font color="#ff0000" size="2">The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID {61738644-F196-11D0-9953-00C04FD919C1} to the user <serverName>\<user account> SID (S-1-5-21-<serviceSID>). This security permission can be modified using the Component Services administrative tool.</font></font> Fortunately Mike Hamilton has a great <a href="http://geekswithblogs.net/mhamilton/archive/2006/12/19/101568.aspx" target="_blank">blog entry</a> explaining how to resolve this. <blockquote> You may see this error - more than once - when working with your Microsoft Office SharePoint Server (MOSS) 2007 deployment. This animal / error generally shows itself after you have applied an upgrade to an existing deployment. For example, when upgrading from B2 MOSS to B2TR MOSS - or when applying a special service pack from MSFT - you may begin to see a lot of these errors pop up in the SYSTEM event log. The error CLSID is followed by a class ID for the DCOM+ application that the <em>service account</em> trying to <em>activate</em> that application - does NOT have permission to activate. For example, let's say I installed MOSS on a server, and used the account mossService as the <em>service account</em> (a least privileged, user account you created to run the MOSS service(s))., when I get this error, I could very well see an error like the following: <font size="1"><font color="#ff0000" size="2">The application-specific permission settings do not grant Local Activation permission for the COM Server application with CLSID </font></font> <font size="1"><font color="#ff0000" size="2">{61738644-F196-11D0-9953-00C04FD919C1}</font></font> <font size="1"><font color="#ff0000" size="2">to the user <serverName>\mossService SID (S-1-5-21-<serviceSID>). This security permission can be modified using the Component Services administrative tool.</font></font> <font size="1"><font size="3">Copy the GUID following the CLSID above, and Start-->Run-->regedit</font></font> <font size="1"><font size="3">With the registry editor open, ensure that your cursor is on the computer at the beginning of the tree (make sure you are not in the middle of some previous edit session in the registry editor).</font></font> <font size="1"><font size="3">Edit-->Find and paste in the GUID. It'll stop at the application entry - and you will want to note the application name on the right side pane. In this example, it was the <font color="#0000ff">IIS WAMREG admin service </font><font color="#000000">that popped up.</font></font></font> <font size="1"><font size="3">Now, open Component Services (typically, from the server - Start-->Administrative Tools-->Component Services), expand Component Services, Computers, My Computer, DCOM Config. Scroll down and find the application (IIS WAMREG in this case). Right-Click-->Properties and select the Security tab. You'll have some options here - the first block Launch and Activation Permissions - ensure that the Customize radio button is selected, and click Edit. Now, add your service account - giving it launch and activate - and in some requirements - remote launch / activate permission.</font></font> <font size="1"><font size="3">Restart IIS and continue on.</font></font> </blockquote> </p> <div style='clear: both;'></div> </div> <div class='metadata1'> <p class='metadata'><small> <span> <abbr class='post_date' title='Tuesday, June 05, 2007'>Tuesday, June 05, 2007</abbr></span> | <span class='post-icons'> <a href='http://www.blogger.com/comment.g?blogID=7408302771999513124&postID=2881365759173586271' onclick=''>0 Comments</a> </span></small> </p> <p class='post-footer-line post-footer-line-2'></p> <p class='post-footer-line post-footer-line-3'></p> </div> </div> <div class='post hentry'> <script type='text/javascript'> var timestamp = "Saturday, June 02, 2007"; if (timestamp != '') { var timesplit = timestamp.split(","); var date_yyyy = timesplit[2]; var timesplit = timesplit[1].split(" "); var date_dd = timesplit[2]; var date_mmm = timesplit[1].substring(0, 3); } </script> <div class='the_date'> <div class='date_m'><script type='text/javascript'>document.write(date_mmm);</script></div> <div class='date_d'><script type='text/javascript'>document.write(date_dd);</script></div> </div> <a name='3140401754221959865'></a> <h2> <a href='http://www.venkat.org/2007/06/sql-server-reclaim-your-unused-table.html'>SQL Server : Reclaim your unused table space</a> </h2> <div class='post-header-line-1'> <span class='post-author vcard'> Posted by <span class='fn'>Venkat Varkala</span> </span> <span class='files'> Labels: <a href='http://www.venkat.org/search/label/SQL%20Server' rel='tag'>SQL Server</a> </span> </div> <div class='entry'> <p>I have a website, and its database has grown to 8 Gigs but my hosting contract supports only 4 gigs. This has become such a big problem. I deleted 6 months of data but still the database was 7 gigs. I cannot afford to buy that kind of database space thought of taking my website down but luckily I was able to figure out how to reclaim usnused space in database. Getting the <a href="http://www.4guysfromrolla.com/webtech/032906-1.shtml" target="_blank">database size by tables</a> really helped me understand how my data is distributed among tables. <p align="center"> <em>EXEC sp_MSforeachtable @command1="EXEC sp_spaceused '?'"</em></p> Above command gives database size by table and also shows you the unused table space. <a href="http://msdn2.microsoft.com/en-us/library/aa258808(sql.80).aspx" target="_blank">DBCC CLEANTABLE</a> can be used to clean up the unused space in a table, though this cleaned up my unused table space but it still didn't decrease the database size tries shriking database and file but no luck. <a href="http://msdn2.microsoft.com/en-us/library/ms188388.aspx" target="_blank">ALTER INDEX</a> can be used to rebuild the Indexes, when I rebuilt the indexes the database size decreased to 3.8 gigs... never knew indexes will take up so much space. <a href="http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocSP.htm" target="_blank">http://www.mssqlcity.com/Articles/Undoc/SQL2000UndocSP.htm</a> has good list of SQL 2000 undocumented stored procedures. </p> <div style='clear: both;'></div> </div> <div class='metadata1'> <p class='metadata'><small> <span> <abbr class='post_date' title='Saturday, June 02, 2007'>Saturday, June 02, 2007</abbr></span> | <span class='post-icons'> <a href='http://www.blogger.com/comment.g?blogID=7408302771999513124&postID=3140401754221959865' onclick=''>0 Comments</a> </span></small> </p> <p class='post-footer-line post-footer-line-2'></p> <p class='post-footer-line post-footer-line-3'></p> </div> </div> <div class='post hentry'> <script type='text/javascript'> var timestamp = "Saturday, June 02, 2007"; if (timestamp != '') { var timesplit = timestamp.split(","); var date_yyyy = timesplit[2]; var timesplit = timesplit[1].split(" "); var date_dd = timesplit[2]; var date_mmm = timesplit[1].substring(0, 3); } </script> <div class='the_date'> <div class='date_m'><script type='text/javascript'>document.write(date_mmm);</script></div> <div class='date_d'><script type='text/javascript'>document.write(date_dd);</script></div> </div> <a name='3586466947808217319'></a> <h2> <a href='http://www.venkat.org/2007/06/sql-server-management-studio-cannot.html'>SQL Server Management Studio cannot create diagrams</a> </h2> <div class='post-header-line-1'> <span class='post-author vcard'> Posted by <span class='fn'>Venkat Varkala</span> </span> <span class='files'> Labels: <a href='http://www.venkat.org/search/label/SQL%20Server' rel='tag'>SQL Server</a> </span> </div> <div class='entry'> <p>I always get below error while trying to create a database diagram in SQL Server 2005 Management Studio. <blockquote> <em>"Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects."</em></blockquote> From my experience, this problem usually occurs with restored databases and there are two reasons, <ol> <li>it is always recommended to restore databases with "sa" as owner.</li> <li>the database is SQL 2000 database and restored to a SQL 2005 Database engine</li> </ol> There are two approaches to this problem <strong>Approach 1</strong> Run below statements on your database (of course replace "YOUR_DATABASE_NAME" with your database name) ALTER AUTHORIZATION ON DATABASE::[YOUR_DATABASE_NAME] TO sa go EXECUTE AS USER = N'dbo' REVERT go In case you get below error after running above statement, follow Approach 2 <em>Msg 325, Level 15, State 1, Line 1 Incorrect syntax near 'REVERT'. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the stored procedure sp_dbcmptlevel.</em> <strong>Approach 2</strong> If changing the owner to a valid user doesn't resolve this try following below steps <ol> <li>Go to database properties.</li> <li>Select Options.</li> <li>Change "Compatibility Level" Dropdown to "SQL Server 2005(90)"</li> </ol> <a href="http://www.venkat.org/wp-content/uploads/2007/06/slqserverdiagram.JPG" title="slqserverdiagram.JPG"></a> <p style="text-align:center;"><a href="http://www.venkat.org/wp-content/uploads/2007/06/slqserverdiagram.JPG" title="slqserverdiagram.JPG"><img src="http://www.venkat.org/wp-content/uploads/2007/06/slqserverdiagram.JPG" alt="slqserverdiagram.JPG" height="229" width="495" /></a></p> </p> <div style='clear: both;'></div> </div> <div class='metadata1'> <p class='metadata'><small> <span> <abbr class='post_date' title='Saturday, June 02, 2007'>Saturday, June 02, 2007</abbr></span> | <span class='post-icons'> <a href='http://www.blogger.com/comment.g?blogID=7408302771999513124&postID=3586466947808217319' onclick=''>0 Comments</a> </span></small> </p> <p class='post-footer-line post-footer-line-2'></p> <p class='post-footer-line post-footer-line-3'></p> </div> </div> <!-- google_ad_section_end --> </div> <div class='blog-pager' id='blog-pager'> <span id='blog-pager-newer-link'> <a class='blog-pager-newer-link' href='http://www.venkat.org/search?updated-max=2007-09-20T00:58:00-04:00&max-results=7&reverse-paginate=true' id='Blog1_blog-pager-newer-link' title='Newer Posts'>Newer Posts</a> </span> <span id='blog-pager-older-link'> <a class='blog-pager-older-link' href='http://www.venkat.org/search?updated-max=2007-06-02T18:41:00-04:00&max-results=7' id='Blog1_blog-pager-older-link' title='Older Posts'>Older Posts</a> </span> <a class='home-link' href='http://www.venkat.org/'>Home</a> </div> <div class='clear'></div> <div class='blog-feeds'> <div class='feed-links'> Subscribe to: <a class='feed-link' href='http://www.venkat.org/feeds/posts/default' target='_blank' type='application/atom+xml'>Posts (Atom)</a> </div> </div> </div></div> </div><!--Entry--> </div><!--post--> </div><!-- container --> <div class='sidebar'> <form action='/search' id='search' method='get'> <input id='s' maxlength='50' name='q' onblur='if (this.value == "") {this.value = "To search, type and hit enter";}' onfocus='if (this.value == "To search, type and hit enter") {this.value = "";}' size='18' type='text' value='To search, type and hit enter'/> </form> <div class='lsidebar'> </div> <div class='rsidebar'> <div class='rsidebar'> <ul><li> <div class='section' id='lsidebar1'><div class='widget Label' id='Label1'> <h2> Categories </h2> <div class='widget-content'> <ul> <li> <a dir='ltr' href='http://www.venkat.org/search/label/ASP.net'> ASP.net </a> <span dir='ltr'> (8) </span> </li> <li> <a dir='ltr' href='http://www.venkat.org/search/label/DNN'> DNN </a> <span dir='ltr'> (4) </span> </li> <li> <a dir='ltr' href='http://www.venkat.org/search/label/SharePoint'> SharePoint </a> <span dir='ltr'> (44) </span> </li> <li> <a dir='ltr' href='http://www.venkat.org/search/label/SQL%20Server'> SQL Server </a> <span dir='ltr'> (7) </span> </li> <li> <a dir='ltr' href='http://www.venkat.org/search/label/Tech%20Blogs'> Tech Blogs </a> <span dir='ltr'> (10) </span> </li> <li> <a dir='ltr' href='http://www.venkat.org/search/label/Uncategorized'> Uncategorized </a> <span dir='ltr'> (2) </span> </li> </ul> <div class='clear'></div> <span class='widget-item-control'> <span class='item-control blog-admin'> <a class='quickedit' href='//www.blogger.com/rearrange?blogID=7408302771999513124&widgetType=Label&widgetId=Label1&action=editWidget§ionId=lsidebar1' onclick='return _WidgetManager._PopupConfig(document.getElementById("Label1"));' target='configLabel1' title='Edit'> <img alt='' height='18' src='http://img1.blogblog.com/img/icon18_wrench_allbkg.png' width='18'/> </a> </span> </span> <div class='clear'></div> </div> </div><div class='widget HTML' id='HTML2'> <div class='widget-content'> <!-- RELATED CONTENT WIDGET START --> <script type="text/javascript"> var PLUCKIT_APIKEY = "4caa41ce-45c1-41c6-a89a-aa39a639534e"; var PLUCKIT_WIDGET_OPTIONS = { 'contentType' : 'all', 'showThumbnail' : 'false', 'showAbstract' : 'true', 'maxResults' : '5', 'showComments' : 'false', 'showRecommendations' : 'false' } </script><script src="http://pluckit.demandmedia.com/Widgets/v1/PluckItRelatedContentWidget/generated.js?apiKey=4caa41ce-45c1-41c6-a89a-aa39a639534e" type="text/javascript"></script> <!-- RELATED CONTENT WIDGET END --> </div> <div class='clear'></div> <span class='widget-item-control'> <span class='item-control blog-admin'> <a class='quickedit' href='//www.blogger.com/rearrange?blogID=7408302771999513124&widgetType=HTML&widgetId=HTML2&action=editWidget§ionId=lsidebar1' onclick='return _WidgetManager._PopupConfig(document.getElementById("HTML2"));' target='configHTML2' title='Edit'> <img alt='' height='18' src='http://img1.blogblog.com/img/icon18_wrench_allbkg.png' width='18'/> </a> </span> </span> <div class='clear'></div> </div><div class='widget BlogArchive' id='BlogArchive1'> <h2>Archives</h2> <div class='widget-content'> <div id='ArchiveList'> <div id='BlogArchive1_ArchiveList'> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/search?updated-min=2008-01-01T00:00:00-05:00&updated-max=2009-01-01T00:00:00-05:00&max-results=17'>2008</a> <span class='post-count' dir='ltr'>(17)</span> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2008_09_01_archive.html'>September</a> <span class='post-count' dir='ltr'>(7)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2008_08_01_archive.html'>August</a> <span class='post-count' dir='ltr'>(6)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2008_07_01_archive.html'>July</a> <span class='post-count' dir='ltr'>(3)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2008_04_01_archive.html'>April</a> <span class='post-count' dir='ltr'>(1)</span> </li> </ul> </li> </ul> <ul class='hierarchy'> <li class='archivedate expanded'> <a class='toggle' href='javascript:void(0)'> <span class='zippy toggle-open'>▼ </span> </a> <a class='post-count-link' href='http://www.venkat.org/search?updated-min=2007-01-01T00:00:00-05:00&updated-max=2008-01-01T00:00:00-05:00&max-results=35'>2007</a> <span class='post-count' dir='ltr'>(35)</span> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_10_01_archive.html'>October</a> <span class='post-count' dir='ltr'>(4)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_09_01_archive.html'>September</a> <span class='post-count' dir='ltr'>(8)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_08_01_archive.html'>August</a> <span class='post-count' dir='ltr'>(1)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_07_01_archive.html'>July</a> <span class='post-count' dir='ltr'>(3)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate expanded'> <a class='toggle' href='javascript:void(0)'> <span class='zippy toggle-open'>▼ </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_06_01_archive.html'>June</a> <span class='post-count' dir='ltr'>(9)</span> <ul class='posts'> <li><a href='http://www.venkat.org/2007/06/deploying-moss-using-dba-created.html'>Deploying MOSS using DBA created databases</a></li> <li><a href='http://www.venkat.org/2007/06/site-definition-is-it-really-obsolete.html'>Site Definition "SPS", is it really obsolete???</a></li> <li><a href='http://www.venkat.org/2007/06/awesome-video-of-kite-flying.html'>Awesome Video of Kite Flying</a></li> <li><a href='http://www.venkat.org/2007/06/documenttemplate-element-contenttype-vs.html'>DocumentTemplate Element (ContentType) Vs. Documen...</a></li> <li><a href='http://www.venkat.org/2007/06/understanding-webtempxml.html'>Understanding webtemp*.xml</a></li> <li><a href='http://www.venkat.org/2007/06/reporting-services-add-in-reportserver.html'>Reporting Services Add-in : ReportServer Feature i...</a></li> <li><a href='http://www.venkat.org/2007/06/reporting-services-add-in-installation.html'>Reporting Services Add-in Installation Error: The ...</a></li> <li><a href='http://www.venkat.org/2007/06/sql-server-reclaim-your-unused-table.html'>SQL Server : Reclaim your unused table space</a></li> <li><a href='http://www.venkat.org/2007/06/sql-server-management-studio-cannot.html'>SQL Server Management Studio cannot create diagram...</a></li> </ul> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_05_01_archive.html'>May</a> <span class='post-count' dir='ltr'>(4)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_04_01_archive.html'>April</a> <span class='post-count' dir='ltr'>(2)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2007_03_01_archive.html'>March</a> <span class='post-count' dir='ltr'>(4)</span> </li> </ul> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/search?updated-min=2006-01-01T00:00:00-05:00&updated-max=2007-01-01T00:00:00-05:00&max-results=13'>2006</a> <span class='post-count' dir='ltr'>(13)</span> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2006_09_01_archive.html'>September</a> <span class='post-count' dir='ltr'>(1)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2006_06_01_archive.html'>June</a> <span class='post-count' dir='ltr'>(2)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2006_05_01_archive.html'>May</a> <span class='post-count' dir='ltr'>(1)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2006_02_01_archive.html'>February</a> <span class='post-count' dir='ltr'>(7)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2006_01_01_archive.html'>January</a> <span class='post-count' dir='ltr'>(2)</span> </li> </ul> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/search?updated-min=2005-01-01T00:00:00-05:00&updated-max=2006-01-01T00:00:00-05:00&max-results=23'>2005</a> <span class='post-count' dir='ltr'>(23)</span> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2005_11_01_archive.html'>November</a> <span class='post-count' dir='ltr'>(1)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2005_09_01_archive.html'>September</a> <span class='post-count' dir='ltr'>(3)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2005_08_01_archive.html'>August</a> <span class='post-count' dir='ltr'>(9)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2005_07_01_archive.html'>July</a> <span class='post-count' dir='ltr'>(9)</span> </li> </ul> <ul class='hierarchy'> <li class='archivedate collapsed'> <a class='toggle' href='javascript:void(0)'> <span class='zippy'> ►  </span> </a> <a class='post-count-link' href='http://www.venkat.org/2005_01_01_archive.html'>January</a> <span class='post-count' dir='ltr'>(1)</span> </li> </ul> </li> </ul> </div> </div> <div class='clear'></div> <span class='widget-item-control'> <span class='item-control blog-admin'> <a class='quickedit' href='//www.blogger.com/rearrange?blogID=7408302771999513124&widgetType=BlogArchive&widgetId=BlogArchive1&action=editWidget§ionId=lsidebar1' onclick='return _WidgetManager._PopupConfig(document.getElementById("BlogArchive1"));' target='configBlogArchive1' title='Edit'> <img alt='' height='18' src='http://img1.blogblog.com/img/icon18_wrench_allbkg.png' width='18'/> </a> </span> </span> <div class='clear'></div> </div> </div> <div class='widget HTML' id='HTML1'> <h2>Live Traffic Feed</h2> <div class='widget-content'> <ul> <script type="text/javascript" src="http://feedjit.com/serve/?bc=44494D&tc=FFFFFF&brd1=44494D&lnk=D7DFF0&hc=44494D&ww=180"></script><noscript><a href="http://feedjit.com/">Feedjit Live Blog Stats</a></noscript> </ul> </div> </div></div> </li></ul> </div> </div> </div> <div id='footer'> <p> <br/>Copyright © 2008 Bloggerized by : <a href='http://www.gosublogger.com'>GosuBlogger</a><br/> <a href='http://blog.eches.net/themes/'>Langit</a>: Designed by <a href='http://blog.eches.net'>Eches</a> Langit <a href='http://www.eblogtemplates.com/langit-blogger/'>Blogger template</a> distributed by eBlog Templates <br/> </p> </div> </div><!-- c_wrapper --> </div><!-- wrapper --> <script type='text/javascript'> var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http://www."); document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E")); </script> <script type='text/javascript'> var pageTracker = _gat._getTracker("UA-76792-1"); pageTracker._trackPageview(); </script> <script type="text/javascript"> if (window.jstiming) window.jstiming.load.tick('widgetJsBefore'); </script><script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/2499618864-widgets.js"></script> <script type="text/javascript" src="https://apis.google.com/js/plusone.js"></script> <script type='text/javascript'> if (typeof(BLOG_attachCsiOnload) != 'undefined' && BLOG_attachCsiOnload != null) { window['blogger_templates_experiment_id'] = "templatesV1";window['blogger_blog_id'] = '7408302771999513124';BLOG_attachCsiOnload('archive_'); }_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7408302771999513124','//www.venkat.org/2007_06_01_archive.html','7408302771999513124'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7408302771999513124', 'bloggerUrl': 'http://www.blogger.com', 'title': 'Catch my Point', 'pageType': 'archive', 'url': 'http://www.venkat.org/2007_06_01_archive.html', 'canonicalUrl': 'http://www.venkat.org/2007_06_01_archive.html', 'canonicalHomepageUrl': 'http://www.venkat.org/', 'homepageUrl': 'http://www.venkat.org/', 'blogspotFaviconUrl': 'http://www.venkat.org/favicon.ico', 'enabledCommentProfileImages': true, 'adultContent': false, 'disableAdSenseWidget': false, 'analyticsAccountNumber': '', 'searchLabel': '', 'searchQuery': '', 'pageName': 'June 2007', 'pageTitle': 'Catch my Point: June 2007', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'languageDirection': 'ltr', 'feedLinks': '\74link rel\75\42alternate\42 type\75\42application/atom+xml\42 title\75\42Catch my Point - Atom\42 href\75\42http://www.venkat.org/feeds/posts/default\42 /\76\n\74link rel\75\42alternate\42 type\75\42application/rss+xml\42 title\75\42Catch my Point - RSS\42 href\75\42http://www.venkat.org/feeds/posts/default?alt\75rss\42 /\76\n\74link rel\75\42service.post\42 type\75\42application/atom+xml\42 title\75\42Catch my Point - Atom\42 href\75\42http://www.blogger.com/feeds/7408302771999513124/posts/default\42 /\76\n', 'meTag': '', 'openIdOpTag': '', 'latencyHeadScript': '\74script type\75\42text/javascript\42\76(function() { var b\75window,f\75\42chrome\42,g\75\42tick\42,k\75\42jstiming\42;(function(){function d(a){this.t\75{};this.tick\75function(a,d,c){var e\75void 0!\75c?c:(new Date).getTime();this.t[a]\75[e,d];if(void 0\75\75c)try{b.console.timeStamp(\42CSI/\42+a)}catch(h){}};this[g](\42start\42,null,a)}var a;b.performance\46\46(a\75b.performance.timing);var n\75a?new d(a.responseStart):new d;b.jstiming\75{Timer:d,load:n};if(a){var c\75a.navigationStart,h\75a.responseStart;0\74c\46\46h\76\75c\46\46(b[k].srt\75h-c)}if(a){var e\75b[k].load;0\74c\46\46h\76\75c\46\46(e[g](\42_wtsrt\42,void 0,c),e[g](\42wtsrt_\42,\42_wtsrt\42,h),e[g](\42tbsd_\42,\42wtsrt_\42))}try{a\75null,\nb[f]\46\46b[f].csi\46\46(a\75Math.floor(b[f].csi().pageT),e\46\0460\74c\46\46(e[g](\42_tbnd\42,void 0,b[f].csi().startE),e[g](\42tbnd_\42,\42_tbnd\42,c))),null\75\75a\46\46b.gtbExternal\46\46(a\75b.gtbExternal.pageT()),null\75\75a\46\46b.external\46\46(a\75b.external.pageT,e\46\0460\74c\46\46(e[g](\42_tbnd\42,void 0,b.external.startE),e[g](\42tbnd_\42,\42_tbnd\42,c))),a\46\46(b[k].pt\75a)}catch(p){}})();b.tickAboveFold\75function(d){var a\0750;if(d.offsetParent){do a+\75d.offsetTop;while(d\75d.offsetParent)}d\75a;750\76\75d\46\46b[k].load[g](\42aft\42)};var l\75!1;function m(){l||(l\75!0,b[k].load[g](\42firstScrollTime\42))}b.addEventListener?b.addEventListener(\42scroll\42,m,!1):b.attachEvent(\42onscroll\42,m);\n })();\74/script\076', 'mobileHeadScript': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/76f25a6f2e06af76', 'plusOneApiSrc': 'https://apis.google.com/js/plusone.js', 'sf': 'n'}}, {'name': 'skin', 'data': {'vars': {'titlecolor': '#5DCEFA', 'blogtitlefont': 'normal bold 135% Arial,Sans-serif', 'descriptionfont': 'normal normal 75% Arial,Sans-serif'}, 'override': ''}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\75classic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\75flipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\75magazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\75mosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\75sidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\75snapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\75timeslide'}}}]); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'headerwrapper', null, document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'lsidebar1', null, document.getElementById('Label1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML2', 'lsidebar1', null, document.getElementById('HTML2'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive1', 'lsidebar1', null, document.getElementById('BlogArchive1'), {'languageDirection': 'ltr'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'lsidebar1', null, document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_NavbarView', new _WidgetInfo('Navbar1', 'navbar', null, document.getElementById('Navbar1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML3', 'main', null, document.getElementById('HTML3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'main', null, document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/499663027-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/2392111094-lightbox_bundle.css'}, 'displayModeFull')); </script> </body> </html>