Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot?
Answer / guest
First I will look to ensure that port settings are proper on
server and client Network utility for connections. ODBC is
properly configured at client end for connection ??Makepipe
& readpipe are utilities to check for connection. Makepipe
is run on Server and readpipe on client to check for any
connection issues.
| Is This Answer Correct ? | 1 Yes | 0 No |
Consider a table with 8 rows 4 rows contains value 0 and 4 rows contains value 1.Now write a single update query to make all 0's as 1 and all 1's as 0
7 Answers PMAM IT Services, TCS,
explain different levels of normalization? : Sql server database administration
how to overcome kernel isssues
What is inner join in sql server joins?
How do you troubleshoot errors in a SQL Server Agent Job?
What is blocking and how would you troubleshoot it?
Write down the syntax and an example for create, rename and delete index?
What is resource governor in sql server?
What are the pre-defined functions in the sql server?
How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)
10 Answers Cognizant, Infosys,
Explain the properties of sub-query in sql server?
What is mean by "fill factor" ? and what is mean by "Index "in sql?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)