What are the restraints imposed on the table design by a merge replication?

0 Answers  

---

What is a result set object returned by mssql_query()?

0 Answers  

---

what is integrated security (SSPI). why we use in the connection string?

2 Answers  

---

In which tcp/ip port does sql server run? Can it be changed?

0 Answers  

---

What do you understand by coalesce in sql server?

0 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,

---

Explain what you mean by 3 tier architecture.

0 Answers   TCS,

---

What are security principals used in sql server 2005?

0 Answers  

---

How to list all objects in a given schema?

0 Answers  

---

Explain what are the authentication modes in sql server?

0 Answers  

---

Does a server store data?

0 Answers  

---

What is the tcp/ip port on which sql server runs?

0 Answers  

---