This is where you download SQL Server Management Studio Express (this is the free version of the management tools Lynn was referring to) from:
http://www.microsoft.com/downloads/details.aspx?FamilyId=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
I've just installed the full, non-free version of SQL Server Management Studio on my PC and it appears in the Start menu (on Windows XP) in:
Start > All Programs > Microsoft SQL Server 2005 > SQL Server Management Studio
You don't mention which version of SQL Server you are running, but if it is prior to version 2005, it will be called "Enterprise Manager" instead of "SQL Server Management Studio", as Lynn mentioned.
Note that if your SQL Server is running on a server, as opposed to running on your desktop PC, then SQL Server Management Studio or Enterprise Manager will not automatically be installed on your desktop PC. You'll actually need to get the installation CDs and install the management tools manually, or download and install the free software mentioned above.
Charles Roper
Digital Development Manager | Field Studies Council
http://www.field-studies-council.org | https://twitter.com/charlesroper | https://twitter.com/fsc_digital