Username/Password syntax

[jalbao]

I am using sqlserver 2000.
I am creating a database using sql CREATE DATABASE.
What is the syntax for creating a username/password for the newly created database. I am thinking that there is a way to define the username/password in the CREATE DATABASE query.

 

[tlbroadbent]

The CREATE DATABASE syntax does not include a CREATE user option. Use sp_grantdbaccess.

EXEC sp_grantdbaccess 'loginname', 'username'

See SQL BOL for more details. Terry

http://members.home.net/tlbroadbent/sqlarticles.htm

"I'm not dumb. I just have a command of thoroughly useless information." - Calvin, of Calvin and Hobbes

 

[jalbao]

thanks terry