Unanswered: What is SQL-DMO? i need help remotely accessing sql server
I have a classic problem, i want to access users, roles and create permissions in SQL server using VB, but not get into SQL server Enterprise Manager everytime.
I have come across SQL-DMO and SQL-NS, i was wondering do i need to create the VB app from scratch or use one of the above ulitily which is readily available. If so where can i find the uliltity, cos i could not find it on SQL server Standard Edition CD. Are there any third party software available. Please also check the following links.