Categorysql-server

  • A Favorite Undocumented T-SQL Snippet

    overachiever

    While there are tons of undocumented T-SQL commands out there, one of my all-time favorites is this little gem: It’s not much, but it will show you default details on:  Arguably, there are better ways to retrieve some of this information (like SELECT * FROM sys.dm_server_registry;). But SERVERPROPERTY(‘ErrorLogFileName’) works just fine when looking for low-level…