How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query?
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 |
Post New Answer View All Answers
What is the difference between an index and a unique index?
What is a DBMS, query, SQL?
Which sql server table is used to hold the stored procedure script?
What guidelines should be followed to help minimize deadlocks?
What is the default fill factor value?
What are indexes in ms sql server?
What is the difference between SQL notification and SQL invalidation?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
How do you handle datasets larger than 50 gb?
Tell me about pre-defined functions of sql?
Define outer join in sql server joins?
How do I determine how many instances of sql server are installed on a computer?
What stored by the msdb? : sql server database administration
define and explain the differences between clustered and non-clustered indexes.
What is sql sandbox in sql server?