What is the difference between login and a user?

Answer Posted / laxman

Login is to connect sql server & user is connect individual
db in server.
every db user will maped with login.

Is This Answer Correct ?    30 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is trace flag in sql server?

534


What are date and time data types in ms sql server?

533


what is the information that can be stored inside a bit column? : Sql server database administration

527


Explain “@@rowcount” and “@@error” in sql server?

543


Why use sub query in sql server and list out types of sub queries?

553






Explain optimistic and pessimistic concurrency?

548


Define cursor locking

557


What is the difference between varchar and nvarchar datatypes?

576


How we can compare two database data?

527


What is the recommended total size of your memory optimized tables?

536


What is rs.exe utility?

120


what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

656


What is the purpose of the tempdb database?

581


How do you start single user mode in clustered installations?

530


Explain about integration services of Microsoft SQL server?

596