• Archive for March, 2009

    SharePoint Database SQL Query Tips3

    by  • March 23, 2009 • General • 3 Comments

    Now, we are going to retrive the file details from AllDocs Database. Which has the informations about the files stored in SharePoint List or Library. – Returns all document from all lists availabe in WebApplication SELECT AllDocs.Leafname AS FileName’,                   AllDOcs.Dirname AS ‘Folder Path’,                   AllLists.tp_Title AS ‘List Title’,                  Webs.Title AS ‘Web Title’ FROM AllDocs JOIN AllLists ON AllLists.tp_Id=AllDocs.ListId JOIN Webs ON [...]

    Read more →

    SharePoint Database SQL Query Tips2

    by  • March 19, 2009 • MOSS, SharePoint • 3 Comments

    Today, we are going to see the query for returning Webs and Site Collections available in the Database (WebApplication). –Returns Total Number of Site Collections in WebApplication select  count(*) as ‘Total Site Collection’ from sites –Returns Root Site Title for each Site Collection available in WebApplication  select Title as ‘Root Web Title’, Sites.RootWebId, Sites.Id as ‘Site Collection [...]

    Read more →

    Silverlight 3 Beta and Expression Blend 3 Preview Released

    by  • March 19, 2009 • Expression, Silverlight • 0 Comments

    Microsoft released the Silverlight 3 Beta and Microsoft Expression Blend 3 Preview at Mix09. Just browse the follwoing links to know more information about the releases. What’s New in Expression Blend 3 Preview Silverlight 3 Beta * Silverlight 3 is now available to developers for testing purposes Download Links Silverlight 3 Beta – Windows Developer [...]

    Read more →

    SharePoint Database SQL Query Tips1

    by  • March 18, 2009 • MOSS, SharePoint • 0 Comments

    Today onwards on daily basis, I decided to post the Sql Query to access the SharePoint Databases. To know more about the databases in Sharepoint , check my SharePoint Databases Post. To retrieve all lists from the database, use the following query, select AllLists.tp_Title as ‘List Title’,webs.Title as ‘Web Title’ from dbo.AllLists as AllLists inner [...]

    Read more →

    Excel Service Links

    by  • March 14, 2009 • Excel Services, MOSS, SharePoint, WebService • 0 Comments

    I’m just researching on Excel Services.I found some posts, are usefull to me, so i like to share with you all. MSDN Blog – Excel Services Cum Grano Salis Blog MSDN Library Microsoft Office Online – Excel Services Click on the above links to navigate to those links. Blog this! Bookmark on Delicious Digg this post Recommend [...]

    Read more →

    WSS – User Information List

    by  • March 11, 2009 • SharePoint • 3 Comments

    I did some research on Sharepoint(WSS) Users, about where are the users & their properties are stored.  I got some result with that, So, i like to share that with you all via.. this post, By using the SPWeb.SiteUserInfoList property,we will get a UserInfo list of the site collection of the current web. The title [...]

    Read more →

    SharePoint Databases

    by  • March 10, 2009 • MOSS, SharePoint • 4 Comments

    I did some research on SharePoint Databases and how are they providing datas to SharePoint sites?. Here i am come up with some details of Databases used in SharePoint. Database Name Description Availablity SharePoint_AdminContent_ GUID This is the Central Admin Content database, is used to store all WSS 3.0 / MOSS content. WSS3.0, MOSS  SharePoint_Config [...]

    Read more →

    The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again.

    by  • March 9, 2009 • SharePoint • 2 Comments

    The security validation for this page is invalid. Click Back in your Web browser, refresh the page, and try your operation again. The above error will be thrown at the time of updating Library or Lists items due to authentication problem, or We didn’t have the rights to update the items. By using the follwoing [...]

    Read more →

    Download Document from SharePoint Library using WebService

    by  • March 8, 2009 • General, SharePoint, WebService • 3 Comments

    In this post, I am going to explain about downloading a document from sharepoint library using webservice, For that we need following things, Read the contents from Document, located in SharePoint Library Create and store the contents on a new document in Local Machine To get the contents from Document under Sharepoint library,we shall use [...]

    Read more →