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 |
Explain syntax for dropping triggers?
How to work on DTS?what is the main requirement?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?
How can I check that whether automatic statistic update is enabled or not?
hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.
What is a trace frag? Where do we use it?
What is the syntax for encrypting a column in SQL Server?
What is difference between unique and primary key?
ehat is the default port no of sql 2000?
Is it possible to create tables in stored procedures using a variable for the table name?
What is 3nf normalization?
Are all views updatable ?
Oracle (3259)
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)