Answer Posted / y.narendra kumar

This example renames the contact title column in the
customers table to title.

EXEC sp_rename 'customers.[contact
title]', 'title', 'COLUMN'

What is a synonym for manipulation?

541

---

What is bcp? When does it used?

543

---

Is a primary key unique?

531

---

How to implement service broker?

520

---

Explain the different types of backups available in sql server? : sql server database administration

512

---

---

Explain the dbcc pintable command when would you use it?

501

---

What is dirty page?

563

---

What were the latest updates to SQL Azure service?

92

---

What is the difference between an index and a unique index?

542

---

What do we need queues in sql service broker?

522

---

what is raid and what are different types of raid configurations? : Sql server database administration

536

---

What are the two modes of authentication in sql server?

517

---

Please illustrate physical database architecture? : SQL Server Architecture

525

---

code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

1752

---

Describe the left outer join & right outer join. : sql server database administration

579

---