you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

Explain the use of containers in ssis and also their types?

0 Answers  

---

Explain what is the use of custom fields in report?

0 Answers  

---

How can we get count of the number of records in a table?

0 Answers  

---

How to drop existing views from a database in ms sql server?

0 Answers  

---

---

Explain what is use of dbcc commands?

0 Answers  

---

What is field with example?

0 Answers  

---

About Indexed Views? with example? plz reply...

2 Answers  

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

0 Answers  

---

Tell me what is difference between clustered and non clustered index?

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

Explain the benefits of user-defined functions?

0 Answers  

---