Answer Posted / virendra

It is builtin facility of Sql Server provovided by
microsoft for import and export
database/table/structure/database objects from one database
package/ server to other/differnet.

How to view existing indexes on an given table using sp_help?

1139

---

I create a separate index on each column of a table. What are the advantages and disadvantages of this approach? : Sql server database administration

1090

---

What happens if ntwdblib.dll is missing on your machine?

1144

---

What is the concept of optimization?

1060

---

What is difference between commit and rollback when used in transactions?

959

---

Which tcp/ip port does sql server run on? How can it be changed?

1042

---

What is the difference between count () and rowcount ()?

1027

---

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

1038

---

What is the parse query button used for?

1038

---

what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration

1035

---

What is Federation and Federation Member?

92

---

What is table constraint?

992

---

what is an extended stored procedure? : Sql server database administration

1055

---

How do you make a trace?

1024

---

What is the difference between stored procedure and functions?

1134

---