In our environment, we run the task scheduler as a cluster resource, so that scheduled tasks always run on the active node.  (In ancient history, we would have scheduled tasks that weren't cluster aware - in the event of a failover, we'd have to manually disable task scheduler on the now passive node, and manually enable it on the active ...

I recently posted about the availability of SQL Server 2005 SP3.  I have a bit more information about cumulative updates and the service pack, for those of you who might be confused about the whole mess involving CU#10, CU#11, post-SP3 CU#1, and are wondering whether you need to install some pre-SP3 CUs and then SP3, or SP3 and then the ...

Okay, it happened a couple of days ago; sorry for not noticing.  But SQL Server Release Services / Sustained Engineering has announced that an SP3 Beta has been made available.  The build is 9.00.4028 and you can download it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=D22317E1-BC64-4936-A14B-7A632B50A4CA This is ...