Explain the basic concepts of SQL server architecture?

2 Answers   College School Exams Tests,

---

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

How is a full-text index updated?

0 Answers  

---

Is port 1433 secure?

0 Answers  

---

What are orphan records?

0 Answers  

---

What is a database in ms sql server?

0 Answers  

---

Explain about system database?

0 Answers  

---

How can you get @@error and @@rowcount at the same time?

9 Answers  

---

In the below query i have performed the commit transaction statement but still the values after the save are not saved. Can you please let me know why are the statements after save are rolled back even after commiting the data. help me with the understanding declare @trans2 varchar(10)='transaction2' begin transaction @trans2 insert into emp values(100,'xy',600); save transaction @trans2 insert into emp values(200,'pq',700); insert into emp values(300,'pq',800); commit transaction @trans2 rollback tran @trans2

1 Answers   AllState,

---

What the different types of Replication and why are they used?

0 Answers  

---

What is difference beteen Migration and Upgrdation?

7 Answers   Satyam,

---

hi friends please answer this question ASAP:- how to count the no. of employee in a each department or no. of employee in each location by using emp/dept table

7 Answers   Indecomm,

---