What is the difference between login and a user?
Answer Posted / nidhi shah
A SQL Server login allows a user to connect to a server. A
login is the base concept.
Database user is associated with a login to allow specific
permissions on that database.
DB user without SQL Server login: not possible to create, a
Database User MUST be
related to a SQL Server login.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to insert data into an existing table?
Explain try...catch with sql server?
Where is localdb stored?
What is the default fill factor value?
How to create a simple stored procedure in ms sql server?
What are the advantages of stored procedure in sql server?
What are different types of statements that are supported by sql?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
What is read committed?
What are extended events in sql server?
Sql server reporting services vs. Crystal reports.
What is explicit mode in sql server?
What is view in sql?
What is tablesample?