Hi all,

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.

http://www.microsoft.com/technet/tre...rt10/c3561.asp

http://msdn.microsoft.com/library/de...con01_2yi7.asp