SQL Server Restore - Filestream feature is disabled

I was trying to restore a database in SQL Server 2008 and got the error: Restore failed... FILESTREAM feature is disabled.  It was annoying because I was able to restore another database no problem, but this particular one I couldn't restore.

After much Googling, I figured out how to enable the file stream.  There are two steps:

1. Open SQL Configuration Manager, click on SQL Server Services on the left hand pane, and then right-click SQL Server on the right hand pane.  Select properties.  On the FILESTREAM tab, check off all three options.  OK out of the dialog and restart SQL Server. (Right-click and select restart).
2. Run the following in SQL Management Studio:

EXEC sp_configure filestream_access_level, 2

RECONFIGURE

After that, I was able to restore the database.

Web Templates

I'm always on the lookout for good web templates.  A lot of the ones on the Internet I've found to be either really primative (the free ones), or way too busy (the expensive ones).  My current web site was a free template, though I don't recall where I found it.  It's not bad, and it's served me well for a while.  Even so, I think I'll be replacing it, mostly to get rid of the flash component in the header.  A lot more people are using Safari (via IPhones or IPads) and that browser doesn't support flash.

I recently found this site: http://andreasviklund.com/templates/.  It looks like it has some really nice templates.  The pages seem really 'clean' and also look professional.  And they're free.  What's not to like?

Combo box changing background colour

I had an odd thing happen in one of my Access databases.  On one of the forms, a bunch of the combo boxes were changing colour when they lost the focus.  It worked fine in Access 2003, but the problem appeared when running the program in Access 2007.

To fix, open the form in design view and view the properties of the detail section (assuming that's where the controls are).  There will be a property called 'Alternate Back Color'.  It's likely set to 'No Color'.  Set it to white, or whatever you want the colour of your combo box to be.  That should fix the problem.

LCS Blog

Welcome to my business blog.  I plan to use this blog to both give current and prospective clients an idea of the work I'm currently doing, and to give tips to fellow developers.  There have been numerous occassions where a quick search of Google has revealed an answer to a tricky problem, so I'm going to try to give some of that information back to help others out.