create login 'name' with password='cghhicl' GO DROP

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

Question Posted / jagadeesh

Answer Posted / jagadeesh

create login 'name' with password='cghhicl'
GO
DROP LOGIN name

Is This Answer Correct ?

0 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Explain features of analysis services?

922

What is log shipping?

911

How do database indexes work?

952

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

932

What types of Joins are possible with Sql Server?

1058

What are the ways available in sql server to execute sql statements?

1038

What are the types of subscriptions in SQL Server replication?

961

What are 3 ways to get a count of the number of records in a table?

1017

Does partitioning help performance?

887

What are the main differences between #temp tables and @table variables and which one is preferred?

1013

Write a code to select distinct records without using the DISTINCT keyword.

1049

What is a coalesce function?

1129

Does hive support indexing?

906

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

840

What is default constraint in ms sql server?

966