Answer Posted / kinthada cnu

hi all

sp_rename 'tablename.oldcolumnname','newcolumnname','column'

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.

3857

---

What method is used by the Command classes to execute SQL statements that return single values?

1046

---

What are the different authentication modes in sql server? How can it be changed?

1064

---

How to generate create function script on an existing function?

1091

---

Can we take the full database backup in log shipping?

931

---

Name few of the dcl commands in sql?

990

---

How to fine-tune reports?

264

---

Explain left outer join and right outer join?

1013

---

What do you need to connect php to sql server?

1087

---

What is the difference between row_number and dense_rank?

858

---

What is an inner join?

963

---

What’s the distinction between dropping a info and taking a info offline?

1023

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

2008

---

What is the difference between mysql and mysqli?

1167

---

Which is the main third-party tool used in sql server?

924

---