Category: sqlserver

While there are tons of undocumented T-SQL commands out there, one of my all-time favorites is this little gem: SELECT SERVERPROPERTY(‘ErrorLogFileName’); It’s not much, but it will show you default details on: Where the SQL Server Binaries have been installed Where you can find SQL Server’s log files (as .txt files) Where the default trace…