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

What is cursors? And what are the different types of cursor?

1147

What is the most common trace flags used with sql server?

1052

List out the differences between the clustered index and non-clustered index in sql server?

1010

How we can compare two database data?

954

What is attribute hierarchy? : sql server analysis services, ssas

1028

Where is trigger in sql server?

1052

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

2368

Why the trigger fires multiple times in single login?

1216

How data can be copied from one table to another table?

954

how to determine the service pack currently installed on sql server? : Sql server database administration

977

What is instead of dml trigger?

1009

How can we determine what objects a user-defined function depends upon?

1019

How many types of keys are there?

1035

How will you hide an attribute? : sql server analysis services, ssas

964

Can we call future method from queueable?

1059