jamescoxhead

SELECT distinct [nodeId]
FROM [cmsDataType]
EXCEPT
SELECT distinct dataTypeId
FROM [cmsPropertyType]

Hendy

-- Create a temporary table for all documents which are published and not in the recycle bin
CREATE TABLE #Nodes (id int)
-- Delete all rows if the table exists before
TRUNCATE TABLE #Nodes

-- Insert all nodeIds from all documents which are published and not in the recycle bin
INSERT INTO #Nodes 
    SELECT N.id 
    FROM umbracoNode N
        INNER JOIN cmsDocument D ON N.ID = D.NodeId

csharpforevermore

public class CustomGlobal : UmbracoApplication
	{
		public void Init(HttpApplication application)
		{
			application.PreRequestHandlerExecute += application_PreRequestHandlerExecute;
			application.BeginRequest += this.Application_BeginRequest;
			application.EndRequest += this.Application_EndRequest;
			application.Error += Application_Error;
		}