tags:

views:

21

answers:

1
Q: 

find enabled protocols

Is there a magic TSQL command which can show me the enabled or disabled SQL server protocols? I thought it is select * from sys.endpoints but the state_desc field indicates "started" even for the protocols (which i know from "configuration manager") which is disabled. any comments? version: 2005

A: 

Hmmm interesting. I've done a quick search and the closest I can find is http://stackoverflow.com/questions/1065328/enabling-tcp-ip-protocol-through-t-sql-script which may set you on the right track. From the documentation you can create and manage endpoints from within T-SQL but to enable the protocol then that is a registry setting done with configuration manager. Which seems to make sense from a security view.

David McEwing  2009-07-23 03:55:26
Yea you are right. I will just check it manually.Thanks!
Manjot  2009-07-23 23:43:52

related questions

*= in Sybase SQL
sql missing rows when grouped by DAY, MONTH, YEAR
Adapt Replace all strings in all tables to work with text
Can you call a webservice from TSQL code?
How to tell the data types after executing a stored procedure?
C# - SQLClient - Simplest INSERT
SQL Server: Get data for only the past year
Get last item in a table - SQL
Is there a way to make a TSQL variable constant?
Create a database from another database?
SQL Server PIVOT examples?
What are some references, lessons and or best practices for SQL optimization training.
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Trigger without a transaction?
How do I do an Upsert Into Table?
What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?
How do I avoid using cursors in Sybase (T-SQL)?
Best .NET Solution for Frequently Changed Database
T-Sql date format for seconds since last epoch / formatting for sqlite input
HOWTO - Compare a date string to datetime in SQL Server?
Differences Between MySql and MS SQL
Best method for varchar date validation in Sybase (T-SQL)?
interrogating table lock schemes in T-SQL
Testing for inequality in T-SQL
T-Sql Remove Decimal Point From Money Data Type