Interested to Buy Any Domain ? << Click Here >> for more details...
How to Create Login and User through query in Sql server
2005.and also how to delete Login and User through query?
- 2 Answers
- 5139 Views
- I also Faced
- E-Mail Answers
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
how you can list all the tables in a database?
Write a code to select distinct records without using the DISTINCT keyword.
What happens if you add a new index to large table?
What is an identity?
What is the difference between the application object and session object?
How can we check the sql server version?
what data regions are and what are the different data regions?
What does nvl stand for?
What is a collation in ms sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?
What is subreport?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
Can I disable or restrict ssrs export formats (rendering formats)?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
how to invoke a trigger on demand? : Sql server database administration
