adspace


How can you hide the sql server instances?

Answer Posted / Devesh Singh

To hide SQL Server instances, you can configure SQL Server to listen on a dynamic port or use named pipes instead of TCP/IP. However, it is important to note that these methods are not recommended for production environments as they may cause connectivity issues.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

1022


How to convert character strings into numeric values?

1190


Disadvantages of the indexes?

1223


What is an indexed view?

1022


How to enter binary string literals in ms sql server?

1244


How to remove duplicate rows from table except one?

1088


What is in place upgrade in sql server?

1125


Can one drop a column from a table?

1089


How do I find query history in sql server?

1024


Explain system functions or built-in functions? What are different types of system functions?

1065


What is sql or structured query language?

1227


Why use identity in sql server?

1199


What are the properties of the transaction?

1072


How raid can influence database performance?

1116


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

1299