_controltemplates/TaxonomyPicker.ascx failed in SP2010

_controltemplates/TaxonomyPicker.ascx failed in SP2010

Our SharePoint 2010 started crying late last Friday, of course right when I wanted to leave, and first thing this morning I took a look at the server and found the following errors: Load control template file /_controltemplates/TaxonomyPicker.ascx failed… Fortunately, I’m not the only one who seems to have had this problem pop out of the blue.  I found a solution fairly quickly here.  To summarize, here’s what you do: On the server, navigate to C:program filescommon filesmicrosoft sharedweb server…

Read More Read More

Moving a SharePoint 2010 Web using PowerShell

Moving a SharePoint 2010 Web using PowerShell

One of the tasks I have at my workplace is to “migrate” SharePoint sites from one parent site to another as projects are closed out.  I wanted a solution to keep all of the business’s active project sites separate from their “archived” ones.  The problem arose when that “archive” has to happen.  You can’t just “move” a website in SP2010 (or at least, not in any way I’ve found or researched).  You can, however, export and import the site, so…

Read More Read More

Removing a user from a WSS 2.0 server (not just a site)

Removing a user from a WSS 2.0 server (not just a site)

Yeah, I know, they’re still running WSS 2.0 at my employer. I’m just here to help, not judge. = ) So I get the request (and I got it before and forgot how I did it) from a site admin that they can’t add a user to their new website they created. It says they already exist when clearly they do not in the Manage Users screen. This is generally because the SID of the existing user account doesn’t match…

Read More Read More

Get first occurance of a character in SQL

Get first occurance of a character in SQL

When I need to know the first (or any) occurrence of a character, I’m used to saying something like InStr() for VB or ASP, or String.IndexOf() in .Net, but when I tried to do something like this today (Sept 2009) in SQL for a substring portion of a query I was creating, those obviously aren’t available. Well, in Oracle InStr is available I understand, but we`re talking about SQL. To get the first occurrence of a character in a TEXT field…

Read More Read More

Clear out old selections from “Choose a Dataset” in ReportBuilder 3

Clear out old selections from “Choose a Dataset” in ReportBuilder 3

While working with ReportBuilder 3 there are times when we will move datasets around in SSRS, and old choices made when users connect to those datasets while using ReportBuilder 3 are invalid or just not there.  But the choices remain in ReportBuilder 3!  When you want to connect to these datasets, which may have the same name but just be in a different place, it’s frustrating for both the user and you.  Here’s how to remove those old dataset pointers/shortcuts…

Read More Read More