CREATE LOGIN CREATE USER in SQL 2000

what is the equivalent of the following in SQL 2000

CREATE LOGIN [domain\login] FROM WINDOWS WITH DEFAULT_DATABASE=[Tracker]
CREATE USER [domain\login] FOR LOGIN [domain\login]
LVL 6
anushahannaAsked:
Who is Participating?
 
lundnakCommented:
forgot the login...

EXEC master.dbo.sp_grantlogin @loginame = N'loginname'
0
 
lundnakCommented:
EXEC dbo.sp_grantdbaccess @loginame = N'loginname', @name_in_db = N'username'
0
 
anushahannaAuthor Commented:
how do we mention it is a windows user and not a SQL one?
0
 
lundnakCommented:
EXEC master.dbo.sp_grantlogin @loginame = N'DOMAIN\login'

Because there isn't the @password parameter, it assumes Windows AD.
0
 
anushahannaAuthor Commented:
Thanks lundnak.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.