add user query in ms-sql

just for reference. to create a user in ms-sql

sp_addlogin @loginame = ‘bugtracker’, @passwd = ‘bugtracker123′,
@defdb = ‘bugtracker’

defdb refers to default db.

enjoy!

Comments are closed.