Posted by SQL Enthusiast
Article by our editor
The SQL Server Properties window contains a property which shows whether a SQL Server is in a failover cluster. Unfortunately it doesn’t show the node that the SQL Server is currently running on. However this is readily available from a SQL command by checking a SERVERPROPERTY. Further clustering information is available from a Data Management View (DMV).
Comments (23) • Read full article »
SQL Server agent keeps a log of events in a table, this is used for the ‘View History’ which displays events for a job in the Log File Viewer. This script will delete selected rows from the history table, such as failed job runs.
Comments (2) • Read full article »
More SQL questions »