Answer Posted / sivakumar

Login is authentication into server level
And Users is authentication into object level.

What is lookup override?

957

---

What is the difference between push and pull subscription? : sql server replication

1148

---

What is data source in connection string?

849

---

What is data compression? : sql server database administration

916

---

What the different topologies in which replication can be configured?

1020

---

What is the concept of optimization?

989

---

Explain what is meant by replication of database?

956

---

What objects does the fn_my_permissions function reports on? : sql server security

990

---

What is difference between clustered index and non clustered index?

1027

---

What is sql profiler. What are the default templates with it? : sql server database administration

949

---

How to stop a loop early with break statements in ms sql server?

972

---

What is a file group?

1016

---

How many clustered indexes there can be on table ?

985

---

What is application role in sql server database security? : sql server security

992

---

What do you mean by a dependent functionality in a build?

1062

---