Guys, I have had to take on a dedicated server (windows 2008) and a company has installed/build a data driven web site for me. The site is built in ASP and uses MS SQL. My question is and please remember im not a programmer or server administrator .... how can i view the database they have created in MS SQL? In the past i have used phpmyadmin? Is there a simple tool like this i can use for MS SQL? I would like to be able to see the databases, tables, fields and data? possibiliy export the data out (database dump)? I have full accesss to the dedicated server! I can see the location where the web site (asp files) are located? Just have no idea how to see the dataabase? Anyone help?
If you want to pay for a program, this one is the easiest to use out there: http://www.navicat.com/ They have a SQL server version. SQL Server also has a free management program. http://www.microsoft.com/en-us/download/details.aspx?id=7593 Personally, I do not like it for working with data directly. It is overly complicated. It works great when you need to get into more advanced usage like replication, but Navicat is far superior for the routine stuff.
As Jestep said, SQL Server has a free management program and you can use it to manage every database which is SQL based - MySQL, MSSQL, PostgreSQL, etc
SQL Server Management Studio(SSMS) is the free management tool. Download the correct version and install it.