This is a bit more complex than it should be; I was hoping networksetup would make this easier but, alas. Using netstat -nr appears to be the best way to find your gateway from the command line: 1netstat -nr | grep '^default' | awk '{ print $2 }' If you haven't played around with networksetup, I …

Brandon had this in some of his maintenance plan code and I found myself using it a bit so I thought I'd blog about it. Here is a simple script that reads a file (C:\scripts\maintenanceplans\$sqlversion\template.dtsx), replaces certain placeholders (in this case, [SERVERNAME] and [BACKUPPATH]), then writes a new file …

Someone awesome sent me the code to an iPhone app that he created for RealCajunRecipes.com. I unzipped the file, and opened the project in XCode 4.2. I immediately noticed the upper left hand drop down (what's that called anyway?) said "Base SDK Missing." So I went to all the usual places to change the SDK, I …

Here is a script that will batch import Models, create associated ECT's, and set permissions for users and admins. Please modify the variables as needed. The script does the following: Scans current directory for BDC Export (.bdcm) files Creates the External System/Lob and the External Content Types Creates External …

In order to invest as little effort as possible creating and recreating and recreating my External Content Types on my development server, I exported the ECT's then deleted External Content Types, External Systems, and BDC Models. I saved them all in a directory on the SharePoint server, then I placed …

Today has been miserable. All I wanted to do was import a SharePoint 2007 calendar into SharePoint 2010 to use as sample data for a prototype site. I was caaarraaazzy enough to believe it would be a simple import/export, but no. There's no such thing. Maybe I could use Outlook calendaring or idq files as a medium? No. …

Recently, after importing some BDCM files, I was unable to create new forms based off of my new External Content Types. The error I received was; The system of the external content type cannot be accessed. It is either removed from the Business Data Connectivity Metadata Store or you do not have the necessary …

I hope I never have to use this article, but if I do, it will be a lifesaver. Check out Paul Randal's post on recovering a SUSPECT database that's been detached. He shows not only how to corrupt a database whilst keeping it functional, he also shows just why detaching a SUSPECT database is a horrible idea....and how …

In order to delete a Records Library or Records Center, all holds and records in a library must be removed and the Holds and Processing timer job must be run. If this criteria is not met, the "Delete this Document Library" will not be an option in the library settings. Here is how you can do this …

Note: As of 2025, SharePoint Server 2010 is long out of support. The following script is historical and applies to SharePoint 2010 on‑prem environments. So first, you have to delete all of the content type's children or you'll receive the error "Error: content type in use." Once the dependencies are gone, you …