I think for a lot of DBAs it's a comfort thing as well.

I know I have all my tools set up the way I like them, all my alerts fire...

Cheers for this.. I'll be working on this over the next few days..this will be a great help

Excellent, many thanks.

HooO! any chance of a copy of your script? We're on 2005, so no sql built-ins are available for our PowerShell.

Does your script work on 2005 ?

No, the <<< is inserted by the PowerShell parser to show where the error is in the line.

Personally, I think that just stating line number is enough to find an...

Ahh, never mind. We're on SQL 2005 so this won't work anyway.

Back to roll-my-own, then...

I've set this up as I'm looking to create a full-on daily server checks checks myself, so this was very timely.

I'm getting an error though:

You must provide a value expression...

Definitely 2 monitors.

I often have to review scripts - sometimes many, many scripts. Being able to have a file manager one one screen and SSMS on the other is a...

I've always considered Acces and VB, macros and so forth as very good tools for prototyping.. getting something that both looks and works the way the customer wants very quickly.

I...

Ahh.. cross domain? I have somewhat the same problem since our production servers are not on the same domain as the dev environment and the staging server is on yet...

Assuming you're on a Windows environment, why not use Windows usernames and passwords?

On our DEV, TEST, Staging and UAT boxes, only applications use SQL user accounts, not people.

I get...

Yes, I understand that part,...

I was being a bit facetious...

Yes, it looks to me like a jabbering net card or a faulty cable.

Our hosting provide insists we have a 1Gbit uplink on the mirror....

Well, I'll need to get hold of the original contracts, but I'm thinking that they never specified a private link of any sort.

As with all inherited systems, I'm finding it...

I'm trying to get hold of SLA's and so forth, and yes the ISP is responsive - their suggestion was we go to log Shipping instead of mirroring.