Answer Posted / laxman

Login is to connect sql server & user is connect individual
db in server.
every db user will maped with login.

How many types of relations are there between dimension and measure group? : sql server analysis services, ssas

1246

---

How can a database be repaired?

1032

---

What is the difference between ‘having’ clause and a ‘where’ clause?

1083

---

Can foreign key be duplicate?

1116

---

What do I need to start working with sql studio? : sql server management studio

1156

---

List some major differences between triggers and stored procedures?

977

---

How to insert multiple rows with one insert statement in ms sql server?

1176

---

What is the new security features added in sql server 2014? : sql server security

1045

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1112

---

What are the different types of upgrades that can be performed in sql server?

1212

---

What is #temp and @table variable in SQL server?

1140

---

What is catalog views?

1117

---

What is the standby server?

998

---

Explain about temporary stored procedure?

1091

---

How to list all schemas in a database?

1100

---