Thank you!

Thank you all for your replies.

Thank you, will try that.

What's wrong with the DDL I posted?

andrewd.smith (12/13/2010)

---

How do you identify top-level nodes, that is rows where the PrevID column does not reference any other parent row? Is the PrevID column NULL valued in this case,...

Keith Mescha (12/9/2010)

---

I have this solution partly implemented. I have recently upgraded quite a few servers to Windows 2008 R2 and SQL 2008 R2 and just found out that the...

Srinivas-490730 (11/5/2010)

---

Marios.

Thanks for posting the MP and the relevant scripts.. It helped me a lot.

I also want to know if we can modify these scripts to alert on long running...

GSquared (12/8/2010)

---

On the subject of what's in the DLLs, you may not be able to verify it yourself, but you can insist on a level of code-review and sign-off by...

Geoff A (12/8/2010)

---

i have run into these type of issues before. COTS products and 3rd party vendors are always the culprits.

the only thing i ever demanded was that for those...

GSquared (12/8/2010)

---

It's kind of a big subject.

The security issues come from a couple of factors. First, have you verified the contents of the DLLs that you're loading as assemblies?...

It turned out the ps1 file was readonly; as soon as I made it read-write, issue was fixed.

Silly eh? 🙂

Thank you!

OK, will do

swjohnson (3/19/2007)

---

RAM,

Since this is a SQL 2005 forum, I assume you are using SQL 2k5. As such, you can use some of the Dynamic Management Views (DMV) to tell you...

Thank you, that's what I had gathered from reading BOL, I just wanted to make sure I understood correctly.

It seemed too good to be true... 🙂