login is server level and user is Object level.

What is the difference between login and a user?

Question Posted / siva

Answer Posted / siva

Is This Answer Correct ?

6 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Why use “in” clause in sql server?

1016

What is cross join in sql server joins?

1092

How many types of stored procedures are there in sql server?

972

how many bits ip address consist of? : Sql server database administration

863

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

1012

What is resource db in sql server?

976

What is a DBMS, query, SQL?

1013

How do you trace the traffic hitting a sql server?

1098

What are sp_configure commands and set commands?

974

Explain try...catch with sql server?

989

What is provisioning, billing and metering, and connection routing concepts in the service layer?

113

How to generate create table script on an existing table in ms sql server?

1115

What is multi-statement table-value user-defined function?

954

How many types of objects are there?

958

When should you use an instead of trigger?

932