SQL Server Enterprise Manager (DEMO only)

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)