Nice! I'm going to have to make use of this at some point - some of our users are starting...

Marios Philippopoulos (1/12/2009)

---

GSquared (1/12/2009)

---

I got a similar (may have been the same) error message at one point when the file was not on the same computer as it had been...

GSquared (1/12/2009)

---

I got a similar (may have been the same) error message at one point when the file was not on the same computer as it had been checked in...

GSquared (1/12/2009)

---

I got a similar (may have been the same) error message at one point when the file was not on the same computer as it had been checked in...

Thanks guys for your suggestions.

In the past, I remember running a sql script file on the same folder as the powershell script itself, and getting an error if I did...

henrik staun poulsen (1/8/2009)

---

Hi mararity,

How do you tell the difference between mediocre and great Admin?

We have two people working with the SANs, but are they any good???

I would like...

There is no substitute for experimentation. The best way to learn...

jesse.roberts (1/8/2009)

---

Thanks Marios

The SQL 2000 script is working there was an extra _ in one of the lines but no big deal

I have to test out the SQL 2005...

matt stockham (1/8/2009)

---

I think the point is that if it is known that there will be a significant number of records updated with no change, why update them in the...

TheSQLGuru (1/8/2009)

---

Marios Philippopoulos (1/8/2009)

---

TheSQLGuru (1/8/2009)

---

It is my belief that even if you rewrite the trigger to only do the audit update on rows where something is different between inserted and...

Nilesh Patel (1/8/2009)

---

Marios,

Great article. At last I found something that explains customizing SCOM monitoring from SQL. It seems that the tool is very powerful but hard to learn. I have...

jesse.roberts (1/7/2009)

---

Hey Marios

I've been looking for something like this for a while. We don't really want to store the data for future analysis on a seperate db. Is there anyway...

That's cool.

What tool do you use to work with powershell scripts?

Jeffrey Williams (1/8/2009)

---

You can trap for the errors and display the error messages. Example:

Trap [Microsoft.SqlServer.Management.Common.ExecutionFailureException] {

Write-Output $("Exception: $($_.Exception.Message)");

Write-Output $("Base Exception: $($_.Exception.GetBaseException().Message)");

return;

}

In the above, I am trapping for a specific...

Actually, there was nothing wrong with the original code. Even taking the quotes...