Software for working with SQL Server databases in Windows Server 2008
You can use Management Studio. Download the Express version which, as of SQL Server 2012 Service Pack 1, is fully functional and no longer requires a license and a different installation to gain access to the full set of features. Here is the SP2 version:

http://www.microsoft.com/en-us/download/details.aspx?id=43351

The file you want is SQLManagementStudio_x64_ENU.exe (unless you are on 32-bit, then you want SQLManagementStudio_x86_ENU.exe).

There is some pretty good documentation on how to use Management Studio here:

http://msdn.microsoft.com/en-us/library/ms174173(SQL.110).aspx