cannot disable from the GUI?

The rule(s) for monitoring of Database Mirroring are disabled by default, you will have to locate the rules and enable them.

Looks like there is also an extension pack available:

the other option is to look at the CMD options for outputting a file, EG.

ping http://www.google.co.uk >filename.txt

vijay.singh 97987 (11/30/2010)

---

grahamc (11/30/2010)

---

the problem with pushing the CMD output to variable is that the output is generally more than 1 value (IE. multiple lines or "rows" in SQL Server)

Had...

What "more" do you want?

Personally I would be looking to use the TIME datatype (or a datetime conversion) like this:

select CAST(CAST(hoursFrom as varchar(8)) + ':' + CAST(minsFrom as varchar(8)) as TIME)

from #temp

From this...

There is a SQL Server management pack for SCOM. Have a look at:

http://www.microsoft.com/downloads/en/details.aspx?FamilyId=8C0F970E-C653-4C15-9E51-6A6CADFCA363&displaylang=en

the problem with pushing the CMD output to variable is that the output is generally more than 1 value (IE. multiple lines or "rows" in SQL Server)

Had a similar issue...

WayneS (11/30/2010)

---

If you're using SSMS 2008, there is another neat trick. In the Registered Servers panel, ake separate folders for each logical (to you) group. Then, you can right-click the...

Lowell (11/30/2010)

---

learned something new today; thanks graham; didn't even know about the Registered Servers panel until this post. lots of options like automatic discovery of all servers on the network...

well, if you have auto update stats = ON currently, the update of statistics is running during the day (or whenever the threshold is reached). Not sure you need a...

Well in Management Studio, under the Registered Servers window, you can right click on a folder, go to tasks and import a file, which will do the registering. For the...

I always know the salary or at least range, before going for an interview. As a contractor in the UK/Switzerland, taking a day off (or even half a day) means...

Its about the right amount of snow to bring the entire country to a "grinding halt"... and that will include...

maybe we would be able to better assist you if you told us why. What are you trying do? COALESCE does what it says and does it well. Improper use...