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 beast way to write CTE in SQL Server ?
What is Command line parameters in PLSQL.?
Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?
What is the template in sql?
Explain what is sql server english query?
When does a workload on SQL Azure get throttled?
Different types of keys in SQL?
What are the different types of subquery?
What is database replication? What are the different types of replication you can set up in sql server?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What is the current pricing model of SQL Azure?
define and explain the differences between clustered and non-clustered indexes.
How fixed length strings are truncated and padded?
What happens if you delete a table that is used by a view?
What do you understand by physical_only option in dbcc checkdb?