loquin
05-05-2002, 03:08 PM
DMO = Distributed Management Objects
This tool allows you to log on to an MSDE or SQL Server 7/2000 database, to examine database security, to add users, and to run SQL directly against the database.
In addition, you can print or save the SQL results, and open/save the SQL itself.
It's now a (sort of) Enterprise Manager Lite.
I downloaded the core routines from the web in Jan or Feb and worked on it on and off up until last week,when I got serious about implementing the enhancements that I thought it needed. The basic SQL-DMO code is almost unchanged. I can't remember just where the original source came from; if you recognize it, let me know, as the original author should be recognized.
One area that would be of great benefit for this tool would be to be add support for table/field description and modification.
Feedback is appreciated.
Please Note: this application requires the SQLDMO object library and SQL Namespace Object Library references. These libraries are included with the MSDE or SQL Server installation package.
Also note that this app will only work on MSDE 1.0 / SQL Server 7 (and 6.5 sp5), and NOT on MSDE 2.0 / SQL Server 2000. The reason is the SQL Namespace library. The SQL Server 7 Namespace library is NOT upwards compatable to SQL Server 2K, and while the SQL Namespace library is included with MSDE 1, it is NOT included with MSDE 2 (Only with SQL Server 2K) and it is specifically not included in the redistributable libraries for MSDE 2.
FYI, a decent, very inexpensive, MSDE administrator (for both versions of MSDE) is available at www.msde.biz.
This tool allows you to log on to an MSDE or SQL Server 7/2000 database, to examine database security, to add users, and to run SQL directly against the database.
In addition, you can print or save the SQL results, and open/save the SQL itself.
It's now a (sort of) Enterprise Manager Lite.
I downloaded the core routines from the web in Jan or Feb and worked on it on and off up until last week,when I got serious about implementing the enhancements that I thought it needed. The basic SQL-DMO code is almost unchanged. I can't remember just where the original source came from; if you recognize it, let me know, as the original author should be recognized.
One area that would be of great benefit for this tool would be to be add support for table/field description and modification.
Feedback is appreciated.
Please Note: this application requires the SQLDMO object library and SQL Namespace Object Library references. These libraries are included with the MSDE or SQL Server installation package.
Also note that this app will only work on MSDE 1.0 / SQL Server 7 (and 6.5 sp5), and NOT on MSDE 2.0 / SQL Server 2000. The reason is the SQL Namespace library. The SQL Server 7 Namespace library is NOT upwards compatable to SQL Server 2K, and while the SQL Namespace library is included with MSDE 1, it is NOT included with MSDE 2 (Only with SQL Server 2K) and it is specifically not included in the redistributable libraries for MSDE 2.
FYI, a decent, very inexpensive, MSDE administrator (for both versions of MSDE) is available at www.msde.biz.