Installing Small Business Server 2008 and SQL 2005 Part 2

So now that SBS 2008 is installed, we move on to installing SQL 2005.  Note that a version of SQL 2005 is already installed for a SBSMonitoring, so you are actually installing a DEFAULT server instance.
Before you do the install, however, you need to make a registry change per this link:
http://technet.microsoft.com/en-us/library/cc794697(WS.10).aspx

Installing SQL Server 2005
If you plan [...]

How to move TEMPDB

Sometimes you need to move TEMPDB in SQL Server. Either because you need more space, or if you just don’t like where it is located. To do that, you need to run the following statements replacing “G:\” with the drive and directory location where you want the TEMPDB files. Once you run [...]

SQL Server / Using BCP to create a format file

So you have a database table and you want to make a format file, but who wants to go through and make one by hand?  You can get a head start by using the BCP (Bulk Copy Program) utility to create one for you.
You can use any existing table to do this.  Open up a [...]