Comments on System.What?: Deleting content Types in Sharepoint 2007: A troub...

Great Post. Really helped in solving the issue for...

2011-10-27T09:25:51.350-07:00

Great Post. Really helped in solving the issue for me. Have referred your article in my blogs so that can share it with more people and help the community.
http://community.zevenseas.com/Blogs/Geetanjali/Lists/Posts/Post.aspx?ID=4

Keep up the good work. :)

Hey Josh, I'm not sure what's positive in...

2011-10-13T21:23:01.644-07:00

Hey Josh,

I'm not sure what's positive in SP 2007 with power shell (although I know its available). It IS possible via the .NET API.

As a last resort, consider opening Visual Studio.

Best,
Tyler

I have a site that has a large number of subsites ...

2011-10-13T13:08:25.561-07:00

I have a site that has a large number of subsites and libraries under it. I am trying to remove a content type from the site collection, but there are 6740 libraries(yes, really) that have the content type assigned to them.

Is there a way to remove the content type on a mass scale from the libraries via Powershell for WSS/2007?

Is there any means to delete content types in SP 2...

2011-06-13T12:26:53.670-07:00

Is there any means to delete content types in SP 2010? The table in this query doesn't exist and SharePoint Explorer does not exist for 2010.

In my case the stored procedure to check the conte...

2011-06-03T06:34:22.360-07:00

In my case the stored procedure to check the content type usage returned nothing, but if you go and check the ContentTypeUsage table, it still had an entry for that content type.
Sharepoint manager also shows the usage as 0, but still it can't be deleted

If you want to see the name of the list as well as...

2011-05-16T22:49:57.799-07:00

If you want to see the name of the list as well as the ID use this.

SELECT
ctu.SiteId
, sys.fn_varbintohexstr(ctu.ContentTypeId) AS ID
, ctu.WebId
, ctu.ListId
, ctu.IsFieldId
, ctu.Class
, al.tp_Title
FROM ContentTypeUsage ctu
JOIN AllLists al on al.tp_ID = ctu.ListId
WHERE (sys.fn_varbintohexstr(ContentTypeId) LIKE '[CONTENT TYPE ID]%')

Very useful post! Thanks!

2011-05-12T09:15:18.297-07:00

Very useful post! Thanks!

The easiest way of all is to get hold of the Share...

2011-04-14T04:32:22.865-07:00

The easiest way of all is to get hold of the SharePoint Manager tool on Codeplex. Run SharePoint manager and you can navigate to the site, look at the content type in question and then look at the Usages branch which will tell you the URL of the lists or libraries that use that content type.

There is one more thing you can try in Sharepoint ...

2011-03-29T13:34:42.130-07:00

There is one more thing you can try in Sharepoint 2010. Once you delete all lists or other items that use the content type, check the Recycle Bin for the site and make sure you empty it out. After that, take a look at the Site Collection recycle bin and make sure you empty that out as well.

marvellous. Thank you, it saved me some time and a...

2010-04-20T00:56:56.879-07:00

marvellous. Thank you, it saved me some time and awful fiddling around, indeed.

Just to let you know there an object In the ShareP...

2009-02-19T14:39:00.000-08:00

Just to let you know there an object In the SharePoint Object Model called "SPContentTypeUsage" who is doing all the job without going to the database. You should give it a glance before going to the DB ;-)

This is awesome!! saved me a lot of time... for so...

2009-01-22T08:22:00.000-08:00

This is awesome!! saved me a lot of time... for some reason i could not use the SP as it gave me conversion error from varchar to varbinary i tried to used the convert function but did not work.

Anyway the other SQL query did the job..

Thank you, saved me hours!

2008-11-08T03:28:00.000-08:00

Thank you, saved me hours!

Probably too late, but site id is string,so put it...

2008-10-30T00:10:00.000-07:00

Probably too late, but site id is string,so put it in single quote

Awesome..just what the doctor ordered!!!

2008-10-01T00:19:00.000-07:00

Awesome..just what the doctor ordered!!!

If you're calling it like the blog post suggests (...

2008-05-30T01:05:00.000-07:00

If you're calling it like the blog post suggests ([proc_ListContentTypeInUse]
@SiteId = fab41e81df894799bc2c9c4bcbe6496a0,
@ContentTypeId = 0x010104) and you're getting no results back it means that the given content type (whatever 0x010104 represents) is not being used in the given sub site (whatever that GUID represents).

Hope that helps,
Tyler

Thanks, now it works without errors, but the stran...

2008-05-29T23:03:00.000-07:00

Thanks, now it works without errors, but the strange thing is - it doesn't return any data either.
I've tried the built in SharePoint script:
USE [WSS_Content]
GO

DECLARE @return_value int

EXEC @return_value = [dbo].[proc_ListContentTypeInUse]
@SiteId = fab41e81df894799bc2c9c4bcbe6496a0,
@ContentTypeId = 0x010104

SELECT 'Return Value' = @return_value

GO

that gives me nice errors:
Msg 8114, Level 16, State 1, Procedure proc_ListContentTypeInUse, Line 0
Error converting data type nvarchar to uniqueidentifier.

So i'm pretty much stuck in this .

You bet.

To run a query in the Management S...

2008-05-29T08:22:00.000-07:00

You bet.

To run a query in the Management Studio first connect to it. You can find out how to do that here.

After you've connected you'll see a list of databases on the left hand pane under the name of the server instance that you just connected to.

Right click on the database you want to run a query against and choose 'New Query'. A new query window will come up where you can run some SQL.

At this point you should be able to copy/paste some of the SQL you've seen in this post (and some of the comments) and run it by pressing F5 or clicking the Play button in the tool bar.

If you get an error it'll probably be either cause the SQL syntax is unsound OR the object (like the stored procedure listed above) is not in the database you're currently running queries against. I'd make sure you're running queries against a SharePoint database as opposed to some other SQL Server database (like 'Master'). You can see (and cahnge) which database your queries are running against by looking at the drop down box at the top of the Query Pane.

I hope that helps.

Best,
Tyler

Can anyone tell me how to run stored procedure wit...

2008-05-29T03:25:00.000-07:00

Can anyone tell me how to run stored procedure with MS SQL Server Management Studio? All i see there is scripts and more scripts and if i just copy needed values i get errors... Please just explain how to corectly do this.

Great post man. Thanks a bunch.

2008-04-09T20:47:00.000-07:00

Great post man. Thanks a bunch.

Great post. You saved me some time. Thanx for the ...

2008-04-09T06:35:00.000-07:00

Great post. You saved me some time. Thanx for the info

Ok, you can get the second query from the stored p...

2008-03-17T21:01:00.000-07:00

Ok, you can get the second query from the stored procedure that reuturns the list's name:

exec sp_helptext 'proc_ListContentTypeInUse'

Then, paste this into a new query and add "*" to return all fields from the "ContentTypeUsage" table.

Then using the returned WebId and ListId, you can find the list:

select * from webs where id = GUID'
select * from alllists where tp_id = 'GUID'

Remember that you need to "Allow management of content types" in the List's Advanced Settings then you get delete the List Content Type and finally you can delete the Site Content Type.

Great post - but how do I know which list this c...

2008-03-17T20:50:00.000-07:00

Great post - but how do I know *which* list this content type belongs in?

My result is "Pages" and I have several page libraries in my Site Collection (it's a Publishing/WCM site with multiple sub-sites).

Comments on System.What?: Deleting content Types in Sharepoint 2007: A troub...

Great Post. Really helped in solving the issue for...

Hey Josh, I'm not sure what's positive in...

I have a site that has a large number of subsites ...

Is there any means to delete content types in SP 2...

In my case the stored procedure to check the conte...

If you want to see the name of the list as well as...

Very useful post! Thanks!

The easiest way of all is to get hold of the Share...

There is one more thing you can try in Sharepoint ...

marvellous. Thank you, it saved me some time and a...

Just to let you know there an object In the ShareP...

This is awesome!! saved me a lot of time... for so...

Thank you, saved me hours!

Probably too late, but site id is string,so put it...

Awesome..just what the doctor ordered!!!

If you're calling it like the blog post suggests (...

Thanks, now it works without errors, but the stran...

You bet.To run a query in the Management S...

Can anyone tell me how to run stored procedure wit...

Great post man. Thanks a bunch.

Great post. You saved me some time. Thanx for the ...

Ok, you can get the second query from the stored p...

Great post - but how do I know *which* list this c...

You bet.

To run a query in the Management S...

Great post - but how do I know which list this c...