Answer / Shobhit Kumar Gupta

To hide SQL Server instances, follow these steps:
1. Open SQL Server Configuration Manager.
2. Expand SQL Server Network Configuration -> Protocols for MSSQLSERVER.
3. Right-click on TCP and select Properties.
4. Navigate to the IP Addresses tab.
5. Select the IP address you want to hide and click Edit.
6. Change the TCP Dynamic Ports to a custom port number (not 1433 by default).
7. Click Apply, then OK.
8. Open SQL Server Management Studio and update the connection string to use the new port number.

can we have a nested transaction? : Sql server database administration

1 Answers  

---

How can a database be repaired?

1 Answers  

---

What is lock escalation?

1 Answers  

---

How do you implement one-to-one, one-to-many and many-to- many relationships while designing tables?

4 Answers   Credit Suisse, GCU, Symphony, TCS,

---

What command is used to create a database in the sql server and how?

1 Answers  

---

whats new about truncate in sql server 2008?

1 Answers   MedSave Healthcare, Serco,

---

How do you create type- insensitive operator?

1 Answers   EXL,

---

What stored by the tempdb ? : sql server database administration

1 Answers  

---

How do you send email on SQL Server?

1 Answers   MindCracker,

---

explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

0 Answers  

---

wat wil hapn if we give the both read and deny read permission to user?

1 Answers   IBM,

---

Where are full-text indexes stored?

1 Answers  

---