What is the difference between login and a user?

Answer Posted / visala

login is server level and user is database level.

Is This Answer Correct ?    25 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

509


Indexes are updated automatically is the full-text index also updated automatically?

629


Why do we use functions?

515


What is primary key, unique key, and foreign key?

542


What is “asynchronous” communication in sql server service broker?

547






What’s the use of custom fields in report?

573


between cast and convert which function would you prefer and why?

545


What are the types of indexes?

598


What are the different normalization forms?

620


What is an execution plan? How would you view the execution plan?

551


How to provide default values to stored procedure parameters?

578


what's new in sql server 2016?

565


How many types of built in functions are there in sql server 2012?

493


What are commonly used mssql functions in php?

566


Which are the two editions in which SQL Azure database available?

101