Below powershell command will query one or more servers for a specific hotfix as in the example. cls get-hotfix -id KB2883201 -computername server1, server2
Below query will list the database file locations on a sql server instance. USE master GO SELECT name AS [Logical Name], physical_name AS [DB File Path], type_desc AS [File Type], state_desc AS [State] FROM sys.master_files GO
Click here to download as a PDF or XLS file, the new SQL Server 2012 System Views Map. Click here for the SQL 2008/2008 R2 version.