Efex Database Manager

Your free MSSQL 2000 management tool

Want to try?

Click to Download Current version 1.0, ASP.NET 2.0 (80KB)
Subscribe for updates
Screenshots

Need an update?

You can leave some feedback about out online database manager at the testimonials. Useful ideas will be implemented ASAP. Also you can mail directly to us, especially if you have project to be done

FAQ

SQL Server 2000 Text Data Manipulation - Saturday, December 23, 2006
Sometimes there is a need to manipulate string values using T-SQL code. With SQL Server 2000 you don't have all the same options, but there are enough commands that if correctly used together can result in the same functionality you get with other programming languages.
SQL Server Command Line Tools To Manage Your Server - Saturday, December 23, 2006
Having these commands at your fingertips is very helpful when trying to solve a problem or for just doing general analysis on your database instances.
How to tell what SQL Server version you are running - Saturday, December 23, 2006
Describes the process of determining what service pack is installed on the SQL Server.
Auditing your SQL Server database and server permissions - Saturday, December 23, 2006
One of the things that DBAs need to be aware of is the permissions that are granted at the server level and at the database level. Most instances of SQL Server have several layers of permissions that are granted.  So what is the best way to get an overall look at your permissions that have been set?
Giving and removing permissions in SQL Server - Saturday, December 23, 2006
Giving permissions and removing permissions is not that hard to do within SQL Server, it just takes some time to determine what permissions should be applied.
When not to use the sa password - Saturday, December 23, 2006
With many of the SQL Server installations using mixed mode authentication for custom applications, web based applications or third party application needs, managing the usage and password for the sa login is critical.
SQL Query Analyzer Shortcuts - Saturday, December 23, 2006
There is a lot of functionality as well as a lot of shortcuts built into the tool, but finding the shortcuts or remembering them is sometimes not that easy.
SQL Server - Performing maintenance tasks - Saturday, December 23, 2006
With any database systems there are a couple of key items that help with performance.
Free SQL Server tools from Microsoft - Saturday, December 23, 2006
Thanks to Microsoft there are plenty of additional free tools that can be used to enhance your SQL Server environment.