Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Question Related to VB+SQL

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-05 : 08:03:58
Raj Dhiman writes "How to Create Users in MS-SQL from Visual Baic 6.0 with respective rights?"

simondeutsch
Aged Yak Warrior

547 Posts

Posted - 2003-02-05 : 21:06:56
Use SQL-DMO. This is available as a Reference from the References menu, in the Project menu, as Microsoft SQL DMO Objects. You declare an object of type SQLServer, connect to it using the Connect method (if it's not running, you can start it using the Start method), and you can then add logins via the login collection, or add users via a database's Users collection. For more info, see BOL.

Sarah Berger MCSD
Go to Top of Page
   

- Advertisement -