What is the difference between login and a user?

Answer Posted / siva

login is server level and user is Object level.

Is This Answer Correct ?    6 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is difference between unique and primary key?

480


What are the main differences between #temp tables and @table variables and which one is preferred?

555


What is transaction server implicit?

535


Can we add a cpu to sql server?

526


You want to generate a report that is formatted as a chart. Can you use the report wizard to create such a report?

88






How to attach adventureworkslt physical files to the server?

638


Explain why variables called the most powerful component of ssis?

538


Explain the dirty pages?

580


Write a query to find 5th highest amount paid from the customer table.

538


Where in ms sql server is ’100’ equal to ‘0’?

603


What is the most common type of join?

532


We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?

910


What do you mean by cardinality?

497


Does full backup break log chain?

554


How to create stored procedures with parameters in ms sql server?

529