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  

---

What are the different Topologies in which Replication can be configured?

0 Answers  

---

write the query for taking database backup in sql

10 Answers   ABC, IBM, Logica CMG, MA,

---

What is store procedure? When do you use?

0 Answers  

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---

What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

0 Answers  

---

how to retrive only second row from table in sql server 2000?

15 Answers   Cognizant, CTS,

---

What are pessimistic lock and optimistic lock?

0 Answers  

---

List some case manipulation functions in sql?

0 Answers  

---

Are all views updatable ?

0 Answers   MCN Solutions,

---

What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

---