in

SharePoint Blogs

The Best Place for SharePoint-related Blogs
All Tags » MOSS » MSSQL (RSS)
Need SharePoint Training? Attend a SharePoint Bootcamp!

Did you have a blog here?

Read this for important information on our recovery!

Browse by Tags

  • Email Enabled List Alias Management

    Ever notice that there is not way to centrally manage or get information about email aliases?  Oh that annoys me!  So I did what any self respecting geek would do, and I started taking it apart...  Here are a couple SQL utility scripts to help you get more out of your SharePoint! ...
    Posted to echef (Weblog) by josef.nielsen on 05-16-2008

  • How to clear off a SQL server quickly...

    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...
    Posted to echef (Weblog) by josef.nielsen on 12-05-2007

  • Getting Search Crawl Details from the DB

    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...
    Posted to echef (Weblog) by josef.nielsen on 11-13-2007

  • Details and manual monitoring of the Content DBs

    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...
    Posted to echef (Weblog) by josef.nielsen on 11-08-2007

  • Pulling site collections details via direct SQL query

    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...
    Posted to echef (Weblog) by josef.nielsen on 10-09-2007

  • SQL 2005 Embedded Edition... What the heck is that?

    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...
    Posted to echef (Weblog) by josef.nielsen on 08-23-2007
Page 1 of 1 (6 items)
Need SharePoint Training? Attend a SharePoint Bootcamp!
Posts (c) their respective authors. Everything else (c) 2007 SharePoint Experts