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

Answer Posted / jagadeesh

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

Is This Answer Correct ?    0 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between dropping a database and taking a database offline?

694


What is difference between aggregate and analytic function?

476


Why we use functions in sql server?

513


When should you use an instead of trigger?

549


If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

533






Differentiate between delete and truncate.

573


What is report subscription?

91


What is the temp table?

539


Define magic tables in sql server?

566


What are data driven subscriptions?

79


What is the datatype of rowid?

504


Is there any difference between the primary key and unique key?

565


What are out-of-range errors with date and time literals?

545


What is resultset concur_updatable?

579


What triggers long term care?

552