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

0 Answers  

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

Explain primary key?

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  

---

Why we need to use secondry database file? though, we can do same work using primary database file also.

2 Answers   Microsoft,

---

---

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

What is an entity-relationship diagram (erd)?

0 Answers  

---

How to fetch records from a One to Many relationship table. eg: wanna get details of all orders for a specific customer. (do not want repeatation of master table records for child table records)

2 Answers  

---

What is Data model and how to prepare a data model.?

1 Answers   TCS,

---

How to get the definition of a stored procedure back?

0 Answers  

---

How to define the name and server for a new dsn?

0 Answers  

---