In this article we will take a look at how to identify the location of Resource database in SQL Server using a TSQL script. Importance of Resource Database in SQL Server Microsoft initially introduced Resource database...
Tag - SERVERPROPERTY() SQL Server
Ashish Kumar MehtaSERVERPROPERTY T-SQL Enhancement in SQL Server 2016
Discover the essential SERVERPROPERTY enhancements in SQL Server 2016. In this final part of our 10-part T-SQL series, we show you how to natively track ProductUpdateLevel (CU/SP) and find default file paths without...
Different Ways to Find Default Trace Location in SQL Server
How to Find SQL Server Default Trace Location Starting SQL Server 2005, Microsoft introduced a light weight trace which is always running by default on every SQL Server Instance. The trace will give very valuable...
