i have a database called "BILLING_SYSTEM" in sql server 7.0 and I'm using sql server authentication mode to connect to the database with my username "BS" and password "BS".
where my front-end is a VB6.0 application.
now I want to create this security login "BS/BS" from vb6.0 code without opening the enterprise manager console.
so how can I accomplish that?
or is there any T-SQL command for creating users?
any help on this would be highly appreciated. I have already searched in google for many time and nothing got yet. if somebody has any link to any related resources that becomes helpful too.
help plz...........its urgent...