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 [...]

Installing Small Business Server 2008 and SQL 2005 Part 1

I’m in the middle of an SBS 2008 premium installation – I say “in the middle”, but I’m actually about to start the fourth version of the install.  The first two fell over into the swamp.  The third caught on fire and THEN fell it he swamp – the fourth one – AH – it’s [...]

Small Business Server 2008

I’m in the middle of an SBS 2008 installation.  How fun is that?  It’s the second time.  Maybe 3rd time will be a charm, I don’t know yet.  The first one fell over and sank into the swamp.   It all comes down to which part of “Install in the highlighted partition” didn’t you understand?
Later, after [...]

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 [...]

Run a query on all of the tables in your database

From: http://www.databasejournal.com/features/mssql/article.php/1490661
sp_MSforeachtable
By Brian Knight
Is there such a thing as a task where you would not need a cursor? Hidden in the depths of the Master database are a series of stored procedures that can replace some cursors with these one-liners.
Traditionally if you wanted to run a DBCC CHECKTABLE on every table in a database you’d [...]