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 happens if null values are involved in bitwise operations?
How check triggers in sql server?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
how many triggers you can have on a table? : Sql server database administration
How can we rewrite sub-queries into simple select statements or with joins?
What do you mean by sql server 2005 express management tools?
Explain system scalar functions?
What is the difference between executequery () and executeupdate ()?
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.
What is spid in sql server profiler?
What is difference in performance between insert top (n) into table and using top with insert?
What is SQL Azure Federations?
How to query multiple tables jointly?
How each E-R model constructs can be mapped to the relational model?
Do you know what is openxml in sql server?