How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

---

Write a SQL query in order to merge two different columns into single column?

0 Answers   QuestPond,

---

Can an entity have two primary keys?

0 Answers  

---

Is the primary key column of a table an index in ms sql server?

0 Answers  

---

How to add an address record into adventureworkslt?

0 Answers  

---

---

How to set the current database in ms sql server?

0 Answers  

---

How to defragment table indexes?

0 Answers  

---

Mention the different authentication modes in sql server.

0 Answers  

---

you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?

0 Answers  

---

What is SubQuery in SQL Server 2008

0 Answers   HCL,

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

If we use where clause in the left outer join then how the query would behave/act?

1 Answers  

---