How to create SECURITY LOGIN from front-end coding

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 426,256 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,115 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MS SQL advertiser: Programming Forums

How to create SECURITY LOGIN from front-end coding

•

Join Date: May 2007

Location: India

Posts: 494

Reputation: choudhuryshouvi is an unknown quantity at this point

Rep Power: 2

Solved Threads: 45

choudhuryshouvi choudhuryshouvi is offline

Offline

Posting Pro in Training

How to create SECURITY LOGIN from front-end coding

Mar 10th, 2008

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...

regards
Shouvik

Last edited by choudhuryshouvi : Mar 10th, 2008 at 3:47 am.

Shouvik_The_Expert_Coder
Have a problem? Don't worry just give me a call and I'll fix it for you.

DaniWeb Home > Forums > Web Development > Databases > MS SQL > How to create SECURITY...

How to create SECURITY LOGIN from front-end coding

How to create SECURITY LOGIN from front-end coding

How to create SECURITY LOGIN from front-end coding