June 2, 2008 at 2:21 pm
Does anyone happen to know if there are queries available that could be used to determine which database protocols are enabled on the SQL server and then what the settings are for those protocols? (For example, determining if TCP/IP was enabled and then port it was using.)
Thanks for your assistance.
June 2, 2008 at 2:28 pm
If you're dealing with SQL Server 2005, then yes.
SELECT * FROM sys.endpoints
After that, you can view the various endpoint views. See the Books Online topic Endpoints Catalog views for the complete list.
K. Brian Kelley
@kbriankelley
June 2, 2008 at 2:55 pm
Do you know if there are any queries available for SQL 7 and SQL 2000?
June 2, 2008 at 3:42 pm
I don't think there are queries for this. I'd assume it's in the registery, so perhaps you can xp_regread the data out of there. Might need multiple queries.
June 2, 2008 at 3:43 pm
You should be able to read this from the registry. But why would you want to determine the network protocol settings via SQL?
Best Regards,
Chris Büttner
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy