Yep I'd use Slack, I use it elsewhere and think it works great for certain situations.

For those that haven't used it before, think of it as IRC but with...

99% Virtualised

~100 SQL Servers

1 left that is Physical but we're looking to virtualise it shortly

All appears to have worked fine, incase anyone is reading this in the future I did the following ...

- Created Active Directory Computer Object with the name of the...

Has anyone else done this successfully?

Thanks for the link, this appears to relate to the Failover Cluster AD Account, I've already created this and the Failover Cluster is up and...

Ok, I think I've tracked down part of the problem, it appears the user set the Primary Data Source as the Oracle Connection.

Apparently SSAS will perform a remote query...

I had a similar issue, a user changed their AD Login details and for some reason the old username was still being passed to SQL Server. The user had access...

I managed to track down the issue, in the end it turned out to be...

Just an update for the Check_Backups script ... currently if the servers have different collation the script will fail.

<code>

USE [MonitorDB]

GO

IF NOT EXISTS (SELECT NAME FROM sys.objects WHERE name =...

I had a feeling that would be the case. We're currently migrating an old Datawarehouse from SQL 2000 to SQL 2008 R2 and obviously we want the data to match...

Most tools I've come across charge per server for monitoring which is fine for a couple of servers but if you're running a large number becomes expensive quickly.

In the...

I finally managed to get it back up and running again by just uninstalling windows updates until it started working again. I'm not sure exactly which one fixed it but...

Tried an uninstall of the SQL Server Engine and reinstall and no luck, same error messages in the error log.

I had a...

Nup no luck with the system restore, that was one of the first things I tried. This is the second time it has happened, the first time was a few...