SharePoint Database SQL Query Tips3

3
Posted by Shantha Kumar on 23rd March 2009

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
Webs.Id=AllLists.tp_WebId
ORDER BY webs.title
If you need the file informations about particular document type. Use [...]

SharePoint Database SQL Query Tips2

3
Posted by Shantha Kumar on 19th March 2009

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 ID’ from webs inner [...]

Silverlight 3 Beta and Expression Blend 3 Preview Released

0
Posted by Shantha Kumar on 19th March 2009

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 Runtime
Silverlight 3 Beta – Mac Developer [...]

SharePoint Database SQL Query Tips1

0
Posted by Shantha Kumar on 18th March 2009

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 join dbo.Webs as webs
on [...]

Excel Service Links

0
Posted by Shantha Kumar on 14th March 2009

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.

WSS – User Information List

2
Posted by Shantha Kumar on 11th March 2009

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 of this userinfo [...]

SharePoint Databases

4
Posted by Shantha Kumar on 10th March 2009

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
The configuration database contains data about all the databases [...]

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

0
Posted by Shantha Kumar on 9th March 2009

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 code, We [...]

Download Document from SharePoint Library using WebService

3
Posted by Shantha Kumar on 8th March 2009

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 the GetItem method [...]

No Excel Calculation Services is available in the farm.

3
Posted by Shantha Kumar on 5th March 2009

 This was the error, i recieved recently when i open an Excel sheet in browser.  I didn’t recived this error before, so i searched in recent log file. That file list out the following line
03/04/2009 14:27:33.07    w3wp.exe (0×14C4)    0×020C     Excel Services      Excel Services Web Front End  5pad    Critical   [...]