Answer Posted / infodba

Login is a server principle and User is a database principle

Each server principle can be a guest user as a public role for each database can view any database.

But a contained user of a database cannot access other databases and cannot be a guest login for the server.

What are the advantages of using stored procedures in sql server?

977

---

What is logon trigger?

1048

---

What is 1nf 2nf and 3nf?

860

---

What is delete query?

915

---

how would you store your query in an SSRS report or a Database server?

158

---

What is attribute relationships, why we need it? : sql server analysis services, ssas

923

---

Does windows server 2016 come with sql server?

891

---

how to determine the service pack currently installed on sql server? : Sql server database administration

930

---

How do you size a resultset?

883

---

please differentiate between delete and truncate?

955

---

what is create database syntax? : Sql server database administration

1063

---

What are the different types of locks in the database?

885

---

What is difference between sql and sql server?

950

---

Explain ms sql server reporting services vs crystal reports?

874

---

What is page-level compression?

923

---