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]
CREATE LOGIN [domain\login] FROM WINDOWS WITH DEFAULT_DATABASE=[Tracker]
CREATE USER [domain\login] FOR LOGIN [domain\login]
EXEC dbo.sp_grantdbaccess @loginame = N'loginname', @name_in_db = N'username'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
how do we mention it is a windows user and not a SQL one?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks lundnak.