SQL Server: Get the Detailed Information Via SERVERPROPERTY

  In this article, we will explain How to get the SQL Server Instance Information using “SERVERPROPERTY”? How to get the SQL Server Instance Information remotely? What’s the SERVERPROPERTY? SERVERPROPERTY is a System Defined function used to return the SQL Server Instance Information. SERVERPROPERTY Syntax SERVERPROPERTY ('propertyname') “propertyname“ is one of the following values. MachineName.…

Overview of the Resource Database

Starting with SQL Server 2005, there is a hidden database called the resource database. Microsoft says:

The Resource database is a read-only database that contains all the system objects that are included with SQL Server. SQL Server system objects, such as sys.objects, are physically persisted in the Resource database, but they logically appear in the sys schema…