I'm new to ASP.NET coming from a LAMP background. I have inherited a site running on Windows server 2003 on IIS6 using SQL server 2005. I'm using terminal services to connect to the web server.
The server has Visual Studio 2005 on it, but the project file is not available to me.
I have FTP access and have downloaded a copy of the entire site.
How do I view the database so I can run queries on it? Check data?
I would also like to configure a test environment on the server (test site and test DB). Can I create a new project in VS2005 and drop in all of the site files to work on them? Or is there more to it than this?