| http://www.w3.org/ns/prov#value | - Loved the script, as we come across all types of environments and frequently need the extra info.I added a slight tweak to include SQL Version as part of the output:-- Show instance, SQL version, and port number for SQL 2000/2005/2008/2008R2 Versionset nocount ongoDECLARE @SqlPort Nvarchar(10)DECLARE @instance_name Nvarchar(30)DECLARE @reg_key Nvarchar(500)DECLARE @value_name Nvarchar(20)DECLARE @
|
