SQL Server Setup Discovery Reports & Related Queries

0

http://www.banmark.fi/?aftepatius=conocer-hombres-millonarios-gratis&1c5=3e Microsoft Sql Server has given so many options to check which version of SQL installed on server. With this Discovery Report we can check how many instances installed on the server, what is the version, the instance belong to which edition, how many features are enabled for that instance, whether it is clustered or not.

opzioni binarie la verità To get discovery report you should have access on server:

go here GoTo Start >> All Programs >> Microsoft Sql Server ____ (Highest version available on your system) >> Configuration Tools >> SQL Server Installation Center

see installation_center  discovery_report

como coquetear con un hombre yahoo  

tradesmarter trading i opzioni Query from Sql Server :

http://careermastery.net.au/?pero=Tastylia-Online-Without-Prescription\\ You can also get all above details from sql query-

stockpair app SELECT
SERVERPROPERTY(‘ServerName’) ‘ServerName’
,@@VERSION ‘Version’
,SERVERPROPERTY(‘Edition’) ‘Edition’
,SERVERPROPERTY(‘ComputerNamePhysicalNetBIOS’) ‘ComputerNamePhysicalNetBIOS’
,SERVERPROPERTY(‘MachineName’) ‘MachineName’
,SERVERPROPERTY(‘InstanceName’) ‘InstanceName’
,SERVERPROPERTY(‘IsClustered’) ‘IsClustered’
,SERVERPROPERTY(‘IsFullTextInstalled’) ‘IsFullTextInstalled’
,SERVERPROPERTY(‘IsIntegratedSecurityOnly’) ‘IsIntegratedSecurityOnly’
,SERVERPROPERTY(‘IsSingleUser’) ‘IsSingleUser’
,SERVERPROPERTY(‘LCID’) ‘LCID’
,SERVERPROPERTY(‘LicenseType’) ‘LicenseType’
,SERVERPROPERTY(‘ProcessID’) ‘ProcessID’
,SERVERPROPERTY(‘ProductVersion’) ‘ProductVersion’
,SERVERPROPERTY(‘ProductLevel’) ‘ProductLevel’
,SERVERPROPERTY(‘FilestreamShareName’) ‘FilestreamShareName’
,SERVERPROPERTY(‘FilestreamConfiguredLevel’) ‘FilestreamConfiguredLevel’
,SERVERPROPERTY(‘FilestreamEffectiveLevel’) ‘FilestreamEffectiveLevel’

watch

single rike menn I am Microsoft Certified Professional for querying & Administering Sql Server. I believe “The greatest barrier to success is the fear of failure.”
I am also available at http://dbavimal.blogspot.com

%d bloggers like this: