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

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

2 Answers
5118 Views
I also Faced
E-Mail Answers

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

What is the purpose of update statistics and scope_identity() function?

0 Answers

What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.

0 Answers

How to use values from other tables in update statements in ms sql server?

0 Answers

How to use go command in "sqlcmd"?

0 Answers

How can you append an identity column to a temporary table?

0 Answers

what is Covering Index ?

3 Answers Thomson Reuters,

Can you please explain the difference between function and stored procedure?

0 Answers

How to convert numeric expression data types using the cast() function?