Building a Virtual Cluster Server with VMWare and MSCS

http://techrepublic.com.com/5208-6230-0.html?forumID=102&threadID=220875&messageID=2223505&tag=content;leftCol

What's the uptime of my MSSQL?

Uptime with MSSQL 2005 and MSSQL 2008

SELECT login_time AS 'Started',
DATEDIFF(DAY, login_time, CURRENT_TIMESTAMP) AS 'Uptime in days'
FROM sys.sysprocesses
WHERE spid = 1;
go


Uptime with MSSQL 2000


SELECT login_time AS 'Started',
DATEDIFF(DAY, login_time, CURRENT_TIMESTAMP) AS 'Uptime in days'
FROM sysprocesses
WHERE spid = 1;
go

How to turn on cluster logging in Microsoft

How to turn on cluster logging in Microsoft Cluster :Serverhttp://support.microsoft.com/kb/168801