SQL Server Enterprise Manger clone (demo only, not complete).
This demo can demonstrate that how to use SQLDMO to create your own SQL Server Enterprise Manager which may perform every job the Enterprise Manager can do. In this demo, the following things are included
Enumirating SQL servers on the network
Logging on to any Selected Server using Windows Authentication or User Name and PWD
Getting List of all Data Bases
Getting List of all Tables
Getting List of all Stored Procedures
Getting List of all Users
Getting List of all Views
Getting List of all Roles
Getting List of all Rules
Getting List of all Defaults
Getting List of all User Defined Functions
Getting List of all User Defined Data Types
Getting List of all Accessing properties of each object listed above like date creation, owner etc.
Creating New Database
Creating New Table
Creating New Stored Procedure
Deleting Database
Creating Table
Creating Backup of Database
Restoring Backup
More things can be done by understanding the way these things work. Not very hard, just simple
It will work only if you have SQLDMO Library, If you have SQL Server installed, then it will work definatelly
SQL Server Enterprise Manager (DEMO only) Comments
No comments have been posted about SQL Server Enterprise Manager (DEMO only). Why not be the first to post a comment about SQL Server Enterprise Manager (DEMO only).
(2 Votes)
VBcoders
