Browsed by
Month: June 2011

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

Restore detached content DB list data to another SP 2010 instance

Restore detached content DB list data to another SP 2010 instance

Had quite a scare today, when one of our business users asked why he couldn’t get to his SharePoint 2010 library.  It’s because we blew away that box due to configuration issues, and didn’t realize he was using it.  Oops! Fortunately, our Sr. Network Admin (also the DBA) was smart enough to detach the DB (not drop it).  I looked at the content in SSMS and sure enough, that was where his data was.  Here’s what I did to restore…

Read More Read More

Save Site as Template not available in SharePoint 2010

Save Site as Template not available in SharePoint 2010

For some reason or another I’ve been able to creat a new site then save it as a template in both SP2010 and SP Designer 2010…except all of a sudden.  Not sure why, but when I exported an existing site from another farm (identical SP2010 installation), then imported it into another SP2010 farm the option is gone.  This also happened when I tried uninstalling the template from the Solution Gallery then redeploying it into the same farm.  Fortunately, I happened…

Read More Read More