CREATE LOGIN ra WITH PASSWORD = 'passwd'; USE COREDATA; CR

How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query?

Question Posted / rajiv singh

Answer Posted / rajiv singh

CREATE LOGIN ra
WITH PASSWORD = 'passwd';
USE COREDATA;
CREATE USER ra FOR LOGIN ra;
GO

DROP LOGIN name

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Can you explain what are various ways to enhance the ssrs report?

996

What is sharding?

116

Tell me what are cursors and when they are useful?

944

How to execute stored procedure in select statement sql server?

1048

How to provide values to user defined function parameters?

1001

What is difference between views and tables?

1000

Explain about integration services of Microsoft SQL server?

1028

How do you rebuild an identity column?

943

List the different types of joins?

973

Explain few examples of stored procedure over triggers?

1025

what is a transaction? : Sql server database administration

986

Mention what are the different types of ssrs reports?

150

What is a DBMS, query, SQL?

1041

What is an execution plan? When would you use it?

968

What is data modeling and Reterminal integrity?

1951