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 etl - extraction, transformation, and loading?

958

Why use sub query in sql server and list out types of sub queries?

1047

What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

1051

What is sql server english query?

1196

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

1194

Explain following error properties?

1058

How many types of cursor type are there?

1162

What are indexes in ms sql server?

1113

Explain datetimeoffset data type in sal server 2008?

970

What is multilevel indexing?

977

How to rename databases in ms sql server?

1253

What are the different types of join?

1237

How to use subqueries with the in operators in ms sql server?

1123

When would you use sql joins?

1024

1 01 101 01010

2098