Explain about nested stored procedure?

0 Answers  

---

Can we create nonclustered index in a table without creating a clustered index

1 Answers  

---

How to find the list of fixed hard drive and free space on server?

0 Answers  

---

What is schemabinding a view?

0 Answers  

---

What is lock escalation? : sql server database administration

0 Answers  

---

---

Which tcp/ip port does sql server run on? How can it be changed?

0 Answers  

---

How to Install SQL SERVER 2005 remotely?

1 Answers   IBM,

---

Explain how to maintain a fill factor in existing indexes?

0 Answers  

---

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

---

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,

---

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

---

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

---