1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

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

Question Posted / vamsimadineni

Answers were Sorted based on User's Feedback



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

Answer / 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

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

Answer / jagadeesh

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

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL Server Interview Questions

How do I view a trc file?

0 Answers  

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

Ms sql server index?

0 Answers  

Define candidate key, alternate key, and composite key.

0 Answers  

write the query for taking database restore in sql?

2 Answers  




What is the purpose of the master database?

0 Answers  

How many max. conditions can b written under the WHERE clause? Like select * from [tabnam] WHERE (cond1...or..cond2....or...cond3...and.....so on.....??? (upto how much extent))?????

3 Answers   SAP Labs,

How to find table changes in sql server?

0 Answers  

Do you know what are the differences between lost updates and uncommitted dependencies?

0 Answers  

How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  

can foreign key take role of primary key?

5 Answers   CarrizalSoft Technologies, TCS, Villa Marie,

Explain the different index configurations a table can have?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories