Solved

CREATE LOGIN CREATE USER in SQL 2000

Posted on 2010-09-03
5
400 Views
Last Modified: 2012-05-10
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]
0
Comment
Question by:anushahanna
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:lundnak
ID: 33599784
EXEC dbo.sp_grantdbaccess @loginame = N'loginname', @name_in_db = N'username'
0
 
LVL 7

Accepted Solution

by:
lundnak earned 500 total points
ID: 33599787
forgot the login...

EXEC master.dbo.sp_grantlogin @loginame = N'loginname'
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33599851
how do we mention it is a windows user and not a SQL one?
0
 
LVL 7

Assisted Solution

by:lundnak
lundnak earned 500 total points
ID: 33600005
EXEC master.dbo.sp_grantlogin @loginame = N'DOMAIN\login'

Because there isn't the @password parameter, it assumes Windows AD.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 33601425
Thanks lundnak.
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SqlDataBase 7 46
SQL Update trigger 5 16
What's wrong with this T-SQL Foreign Key? 7 41
Sql Server group by 10 26
Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

786 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question