The SQL Server Web Query application allows you to run queries on any SQL Server database from anywhere via the web. You can also save queries for later use, or recall stored procedures in the database to run. There are also some very basic intellisense-like tools in the application to make writing queries fast and easy, automatically retrieving table and column names in the database, and completing T-SQL and ODBC statements for you.
Whether you’re at home, at work, or on the go with a laptop or internet-capable cell phone, SQL Server Web Query makes it quick and easy to build and execute queries on a remote SQL Server database.
System Requirements Supported Operating Systems: Windows 2000 Service Pack 4; Windows Server 2003; Windows XP, Windows VISTASQL Web Query requires:
- Microsoft SQL Server 7 SP2 or later
- Microsoft .NET SDK 2.0 or Microsoft Visual Studio .NET 2005
- Microsoft Internet Explorer 6 or later
- Microsoft Internet Information Services (IIS) -- optional, a portable web server* is also distributed with the project
- Microsoft ASP.NET AJAX Extensions (http://go.microsoft.com/fwlink/?LinkID=77296)
- Microsoft ASP.NET AJAX Control Toolkit – optional, may be necessary for editing some parts of the application (http://www.codeplex.com/Release/ProjectReleases.aspx?ProjectName=AtlasControlToolkit)
- Click "Release" tab when you're on the "SQL Web Query" project page.
- Click "SqlWebQuery.zip" link under "Runtime Binaries".
- Click "I Agree" button if you agree with the project license.
- Click "Open" or "Save" the zip file "SqlWebQuery.zip" to your computer.
- Extract the zip file "SqlWebQuery.zip". This will create two folders "SqlAdmin" and "SqlWebQuery"
Got questions? Want to contribute?
- Create an IIS website (either a website or "Application" on an existing site). If you are installing this on Windows XP or VISTA you will only be able to create an “Application”.
- Enter a description for your new site. This screen will not be presented if you are installing on Windows XP or VISTA.
- Enter the full path and name of the "SqlWebQuery" directory created from the download as the website home directory.
- Make sure that the Application Pool's user has Read and Execute access to the directory.
- Click "Finish" button.
- Make sure the .NET 2.0 is the current ASP.NET runtime. In IIS console, right click the website just created, choose "Properties" option.
- Run the website.
- Browse the list of the files under the website, right click "default.aspx", and click "browse". That will start the web application.
Check out the SQL Server Community & Samples Discussion Forum