Answer Posted / anwar

Four jobs will create on logshipping

How secure is sql server database?

1013

---

List layers of abstraction microsoft architectured to provide relational db through cloud platform ?

183

---

Which are the new data types introduced in sql server 2008?

881

---

Delete duplicate rows without using rowid.

1532

---

What do you mean by authentication modes in sql server?

1083

---

How to create new tables with "select ... Into" statements in ms sql server?

991

---

What are the key configuration files for sql server reporting services ?

167

---

What are the system database in sql server 2005?

1044

---

Mention the different authentication modes in sql server.

1055

---

Can we perform backup restore operation on tempdb? : sql server database administration

998

---

How to use order by with union operators in ms sql server?

1024

---

Explain what are various ways to enhance the ssrs report?

1044

---

How many databases can we create in a single server?

207

---

What do you understand by user-defined function in the sql server?

953

---

Can we take the full database backup in log shipping?

955

---