What do we need queues in sql service broker?

0 Answers  

---

I am having table Title with TITLE id,Author ID, Publiser ID , table AUTHOR with Author ID, Author Name, table PUBLISER with Pub ID, Pub name Here hot to find out the publiser id who have relesed the books of patriticular author?

3 Answers  

---

Can you use order by when defining a view?

0 Answers  

---

what is hash nonclustered index

0 Answers  

---

What are the indexes in sql server?

0 Answers  

---

---

What is the security principal at the database level that represents your session?

0 Answers  

---

What are the dmvs?

0 Answers  

---

How to replace null values in expressions using isnull()?

0 Answers  

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

What are the recovery models in sql server 2000?

0 Answers  

---

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  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---