That's my MO, too. I don't expect there to...

Thanks!

I got it to work, and I figured out why it didn't work for me the first time. Apparently, if you reset the latency threshold value from Replication Monitor it...

noeld (5/18/2009)

---

Apparently sp_alertmessage was fixed on SP3.

I can't test it right now but it should do the 14161 Error work.

can you try:

EXEC sp_altermessage @message_id = 14161 ,@parameter = 'WITH_LOG'...

Thanks, Steve, these always make for a great reference.

BTW - You might want to change the subtitle which currently reads: "Build List Updated with Cumulative Update 9 for SP2." to...

I ran the following and it did not enable our alerts for latency....

Thanks, I like it!

I did make a couple of minor changes. Our server names are >10 characters and I like to see the run date and run time in descending...

We have SQL 2005 SP3 with CU1 and this still hasn't been fixed. I looked through the CU3 release articles (which were published in April) and doesn't look like it's...

I do not have an answer to your dilemma, but you may want to consider going to SQL 2005 or later. We used to have a lot of replication problems...

Amar Pogaku (1/9/2009)

---

Hello,

Thank you for bringing this to my attention.

The original code I submitted parses fine. But you are right there is something going on when you copy it...

I receive parsing errors:

Msg 102, Level 15, State 1, Procedure OPS_SP_DetailSPID, Line 6

Incorrect syntax near '?'.

Msg 102, Level 15, State 1, Procedure OPS_SP_DetailSPID, Line 13

Incorrect syntax near '?'.

No knock on the script, but I question the value of truly random passwords.

I think I have a pretty good memory. I have my credit card number memorized (okay...

jpowers (10/31/2008)

---

budbeth (10/31/2008)

---

If it were caramel corn, yes, it'd have the sugar.

But I gave "Movie Theater Butter" flavored.

OK, so instead of dental issues, maybe I'm promoting future heart problems....

I think...

tosscrosby (10/31/2008)

---

Just my 2 cents - either the Idera or RedGate product (I want to say Idera but the memory isn't what it used to be!) did not require a...

You're thinking of Carmel corn. Regular popcorn is just corn, oil, and salt.

We all know that Charlie Brown always gets rocks for Halloween. When I was a kid, we had a neighbor lady who used to occasionally place an open-faced peanut butter...