SHAREPOINTSearch.com

So I was asked in an online community how to quickly clean off a SQL Server to rebuild a MOSS Farm.  Although it won't clean up and "add-ins" to the system DB's or any security identities, this does a quick and dirty job... IF object_id('tempdb..#AllDatabases') IS NOT NULL...

Ok, so I must be on a roll... Here's another glorious script that goes directly to the SharePoint DB's... Don't tell Bill! As usual, this is not recommended by MS, etc., etc., etc. This one is to get result sets of your Crawl Details. It will show each attempt to start/stop/delete a crawl...

So our Ad-Hoc environment started growing a bit faster than we had originally anticipated. We knew we would have some disparity between site's content size, so we set our content DB max site limits a bit lower than normal (hey, we have 50 of them, so we thought we'd be safe). The thought was...

I certainly don't recommend making changes to your content DBs directly in SQL, but there's no harm to be had pulling data from the DB's. I found that this was the easiest way to poll data about all farm content DBs and Web Apps listed by Site Collection. Hope you find this useful! /* SiteReport...

So I ran in to a copy of SQL 2005 Embedded today... first time I've seen it. It was on a MOSS install that some folks were testing, and they wanted the content moved over to our Production environment. No Problem, says I... I went to go make a backup of the Context DB to import in to the Production...