SQL – What version of SQL 2005 server am I running?

You can check the version of SQL server running on a machine using the following command in MSQL server management studio:
select @@version
To determine the product version (for example, 9.00.1399.06), the product level (for example, RTM) and the edition (for example, Enterprise Edition) run the following:
SELECT  SERVERPROPERTY(‘productversion’), SERVERPROPERTY (‘productlevel’), SERVERPROPERTY (‘edition’)

Moving TEMPDB in SQL Sever 2005

 
As advised by Microsoft I needed to move the TEMPDB and logs away from the C: drive, in this case I have moved onto a folder called TEMPDB on F:
The following code shows the current location of TEMPDB and logs;
USE TempDB
GO
EXEC
sp_helpfile
GO;
you should see something like this
tempdev 1
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\tempdb.mdf
PRIMARY
6608000 KB
Unlimited
10%
data only
templog 2
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\templog.ldf
NULL
29504 KB
Unlimited
10%
log [...]

SQL 2005 SERVER SET UP

I have set up a new server this week to host SQL server 2005 to manage my count engine.
Spec:
 - Antec Sonata 3 Super Case with 500W aPFC PSU
 - Abit AB9 WiFi iP965, S775, PCI-E (x16),
    DDR2 533/667/800, SATA II, SATA RAID, ATX
 - 4GB (2×2GB) Corsair TwinX XMS2, DDR2 PC2-6400 (800),
    240 Pins, Non-ECC Unbuffered, CAS [...]