What is the difference between login and a user?
Answer Posted / dharmendra k. dixit
Login is the way of authentication into MSSQLServer,
and Users are the members of that Authentication as per
their Access rights for a specific DataBase.
| Is This Answer Correct ? | 20 Yes | 1 No |
Post New Answer View All Answers
Do you know what are pages and extents? : SQL Server Architecture
What is update locks?
Write down the syntax and an example for create, rename and delete index?
Why we should not use triggers?
Explain the xml support sql server extends?
Can you explain various data region available in ssrs with their use?
What is resource governor?
Explain the cursor lock types?
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
How can i Relate Tables in SSIS
What are the parts of a function?
Explain unique key in sql server?
What are scalar functions in sql?
Explain what is dbcc?
I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration