Explain about protocol layer present in SQL server?
- 1 Answers
- 1339 Views
- I also Faced
- E-Mail Answers
Answer Posted / Mahipal Singh
SQL Server communicates with clients using a layered protocol stack. The primary components of the protocol layer are:n
1. Tabular Data Stream (TDS): A binary protocol used for communication between SQL Server and clients. TDS defines various frames for transmitting data, metadata, and control messages.n
2. Network Library: Handles network I/O tasks like opening connections, reading, and writing data packets.n
3. TCP/IP: The primary transport layer protocol used by the network library for communication between SQL Server and clients over a network.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How can you append an identity column to a temporary table?
Can we do dml on views?
What are the properties of the transaction?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
How do I find the sql server version?
What is sql server query analyzer?
What is standby servers? Explain types of standby servers.
What is temporary table in sql server? Why we use temp table?
What is normalization and what are the advantages of it?
How do I start sql server 2017?
How to remove duplicate rows from table except one?
Can you index views?
Can one drop a column from a table?
What are the kinds of subquery?
How do I create a trace in sql server?
