Soltion for error: "The solution cannot be removed when a job is scheduled or running"

if you are getting the following error while deleting solution: The solution cannot be removed when a job is scheduled or running, that means your solution got corrupted while deployment and it is not retractable.
Even if you will see under operation in Central Administration( under "Solution Management"), it will not give you option to retract and it will show error without detail.

Here is the solution to remove corrupted soltuion from sharepoint 2007:

step-1:
get the job id using enumdeployments
stsadm -o enumdeployments
i.e. job id(2529c788-971c-46a3-b69f-a2a0a1fcc851)

step-2:
cancel deployment using job id
stsadm -o canceldeployment -id 2529c788-971c-46a3-b69f-a2a0a1fcc851

step-3:
once job id in step 2 is canceled than retract solution
stsadm -o retractsolution "Yoursolution.wsp" -immediate

step-4:
once retract is completed than delete solution
stsadm -o deletesolution "Yoursolution.wsp" -override

enjoy green coding using free www.code4green.com site

SQL Query To Find out which site template had been used to create a site

Another SQL Query for WSS_Content / sharepoint / Moss database
Find out which site template had been used to create a site entitled

SELECT Title, WebTemplate, ProvisionConfig
FROM dbo.Webs
WHERE Title='Give your siteName'

Enjoy Green coding....
Keep looking for the Free Sharepoint SQL eBook on code4green.com

Basic SharePoint's tables in Content Database

Here is the list of the basic SharePoint's tables in Content Database

Features: information about all the activated features for each site collection or site.
Sites : information about all the site collections for this content database.
Webs : information about all the specific sites (webs) in each site collection.
UserInfo : information about all the users for each site collection.
Groups : information about all the SharePoint groups in each site collection.
Roles : information about all the SharePoint roles (permission levels) for each site.
AllLists : information about lists for each site.
GroupMembership : information about all the SharePoint group members.
AllUserData : information about all the list items for each list.
AllDocs : information about all the documents (and all list items) for each document library and list.
RoleAssignment : information about all the users or SharePoint groups that are assigned to roles.
SchedSubscriptions : information about all the scheduled subscriptions (alerts) for each user. ImmedSubscriptions : information about all the immediate subscriptions (alerts) for each user.

Enjoy Green coding using code4green.com

SQL Queries For Sharepoint's Content Database

Here is the List of some most important SQL Queries for sharepoint/moss's content database:
1. Query to get all the top level site collections
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (ParentWebId IS NULL)

2. Query to get all the child sites in a site collection
SELECT SiteId AS SiteGuid, Id AS WebGuid, FullUrl AS Url, Title, Author, TimeCreated
FROM dbo.Webs
WHERE (NOT (ParentWebId IS NULL))

3. Query to get all the SharePoint groups in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.Groups.ID AS Expr1,
dbo.Groups.Title AS Expr2, dbo.Groups.Description
FROM dbo.Groups INNER JOIN
dbo.Webs ON dbo.Groups.SiteId = dbo.Webs.SiteId

4. Query to get all the users in a site collection
SELECT dbo.Webs.SiteId, dbo.Webs.Id, dbo.Webs.FullUrl, dbo.Webs.Title, dbo.UserInfo.tp_ID,
dbo.UserInfo.tp_DomainGroup, dbo.UserInfo.tp_SiteAdmin, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Email
FROM dbo.UserInfo INNER JOIN
dbo.Webs ON dbo.UserInfo.tp_SiteID = dbo.Webs.SiteId

5. Query to get all the members of the SharePoint Groups
SELECT dbo.Groups.ID, dbo.Groups.Title, dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.GroupMembership INNER JOIN
dbo.Groups ON dbo.GroupMembership.SiteId = dbo.Groups.SiteId INNER JOIN
dbo.UserInfo ON dbo.GroupMembership.MemberId = dbo.UserInfo.tp_ID

6. Query to get all the sites where a specific feature is activated
SELECT dbo.Webs.Id AS WebGuid, dbo.Webs.Title AS WebTitle, dbo.Webs.FullUrl AS WebUrl, dbo.Features.FeatureId,
dbo.Features.TimeActivated
FROM dbo.Features INNER JOIN
dbo.Webs ON dbo.Features.SiteId = dbo.Webs.SiteId AND dbo.Features.WebId = dbo.Webs.Id
WHERE (dbo.Features.FeatureId = '00BFEA71-D1CE-42de-9C63-A44004CE0104')

7. Query to get all the users assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.UserInfo.tp_Title, dbo.UserInfo.tp_Login
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN
dbo.UserInfo ON dbo.RoleAssignment.PrincipalId = dbo.UserInfo.tp_ID

8. Query to get all the SharePoint groups assigned to roles
SELECT dbo.Webs.Id, dbo.Webs.Title, dbo.Webs.FullUrl, dbo.Roles.RoleId, dbo.Roles.Title AS RoleTitle,
dbo.Groups.Title AS GroupName
FROM dbo.RoleAssignment INNER JOIN
dbo.Roles ON dbo.RoleAssignment.SiteId = dbo.Roles.SiteId AND
dbo.RoleAssignment.RoleId = dbo.Roles.RoleId INNER JOIN
dbo.Webs ON dbo.Roles.SiteId = dbo.Webs.SiteId AND dbo.Roles.WebId = dbo.Webs.Id INNER JOIN
dbo.Groups ON dbo.RoleAssignment.SiteId = dbo.Groups.SiteId AND
dbo.RoleAssignment.PrincipalId = dbo.Groups.ID

Thank you Ethan. For more Sharepoint's content database related topics please visit Ethan's blog: http://vspug.com/ethan/
Enjoy Green coding

MultiColumnLookupField control in sharepoint 2007

Depoyment of MultiColumnLookupField in sharepoint

I was looking for how to use this control into sharepoint, and after doing work around I have got this solution for others:

1. Build your assembly(project) and install it in the GAC on the server.

2. Copy the ascx control(MultiColumnLookupField.ascx) to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\CONTROLTEMPLATES

3. Copy the fldtypesMultiColumnLookup.xml to C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML

4. Reset IIS

Enjoy green coding

Hussain Naqvi

use this online tool for free code generation www.Code4green.com

Features of SharePoint2010

Hi, I have compiled my first eBook on "Features of Moss2010". Please download this free eBook from my code4gree site : http://www.code4green.com/Files/MOSS%202010%20Features.pdf Also, use new version of code4green to generate free code. Enjoy Green Coding....