sys.dm_server_services DMV is available in SQL Server 2008 R2 SP1 and SQL Server 2012. It will return the information about the below SQL Services on the current instance.
You can use the Win32_OperatingSystem class to get the Operating system info.
$hostname = "Enter Computer Name" Get-WmiObject -class win32_operatingsystem -computer $hostname | select-object *
Click Me to download sample database
It is always a risk if the user name & password is equal. You can run the below script to find out the list of User/Login name & password which are equal.
select cast(@@SERVERNAME as varchar(150)) as SQLInstanceName ,name as [LoginName] ,'Password is same as Login Name' [Description] from sys.syslogins WHERE PWDCOMPARE (name,password) = 1
It is always good to have the idea about the database properties while doing the migration, performance tuning or configuration.
You can execute the below script to get the database property information.
select sysDB.database_id, sysDB.Name as 'Database Name', syslogin.Name as 'DB Owner', sysDB.state_desc, sysDB.recovery_model_desc, sysDB.collation_name, sysDB.user_access_desc, sysDB.compatibility_level, sysDB.is_read_only, sysDB.is_auto_close_on, sysDB.is_auto_shrink_on, sysDB.is_auto_create_stats_on, sysDB.is_auto_update_stats_on, sysDB.is_fulltext_enabled, sysDB.is_trustworthy_on from sys.databases sysDB INNER JOIN sys.syslogins syslogin ON sysDB.owner_sid = syslogin.sid
aiDeeva.com 