Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
SELECT id, sName, iStatus FROM [SQL01].[dbo].[KPIDay]
not sure where I need the [sqldatabase].[dbo].[table
SELECT Lead_T.sName AS Expr1, LeadSource_T.sName, TransferClient_T.sName AS Client, TransferSubscription_T.sName AS Subs, LeadTransfer_T.zXUpdtdWhn AS Date, LeadTransfer_T.zXUpdtdBy AS [Updated By], TransferClient_T.id FROM TransferClient_T INNER JOIN LeadSource_T INNER JOIN LeadTransfer_T ON LeadSource_T.id = LeadTransfer_T.FKiSourceID INNER JOIN Lead_T ON LeadTransfer_T.FKiLeadID = Lead_T.id ON TransferClient_T.id = LeadTransfer_T.FKiClientID INNER JOIN TransferSubscription_T ON LeadTransfer_T.FKiSubscriptionID = TransferSubscription_T.id WHERE (LeadTransfer_T.zXUpdtdWhn BETWEEN CONVERT(DATETIME, '2012-10-29 00:00:00', 102) AND CONVERT(DATETIME, '2012-10-29 23:59:59', 102)) AND (TransferClient_T.id = 27) ORDER BY TransferClient_T.zXUpdtdWhn, Date, LeadSource_T.sName DESC