• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• SQL Server Enterprise Manager (DEMO only)

SQL Server Enterprise Manager (DEMO only)

by DevelopersINN (2 Submissions)
Category: Databases/Data Access/DAO/ADO
Compatability: Visual Basic 5.0
Difficulty: Advanced
Date Added: Wed 3^rd February 2021
Rating: (2 Votes)

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

Sameers (theAngrycodeR)

Download SQL Server Enterprise Manager (DEMO only)

Download SQL Server Enterprise Manager (DEMO only) (41 KB)

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).

Post your comment