Rick, here's the resulting HTML. I did fix it so it replaces CRLF and not just LF. It renders perfectly (except for the line break issue...) in Outlook. In gmail,...

I'm an old guy now (58.) I started my career in what was then called MIS (Management Information Systems.) After a few years, it became clear to me that MIS...

@jack-2,

I fixed the one error on operator notification. That was easy, apparently I had no default notify path or something.

I moved the CheckDB step...

Jack Corbett (3/6/2012)

---

Can you try running one of the DBCC CHECKDB commands listed in the T-SQL window by itself and see if you get a better error message?

You...

I ran the "sp_configure 'Allow Updates', 0;" statement. Result was "...changed from 0 to 0. Run reconfigure..."

Don't know what 'reconfigure' is, but it appears Allow Updates was already zero....

Maint plan...

Forgive me, I had intended to show that, but it got covered by another window. Here it is.

For some reason, when I copy and paste from the SQLServerCentral code boxes, I get unprintable (and unacceptable) characters in place of leading spaces on many lines. I just paste...

Perfect. Thank you.

Here's the exact procedure (couple of typos corrected) that I ended up creating:

USE [xxxx]

GO

/****** Object: StoredProcedure [dbo].[cpas_POIDVendorProjectDate] Script Date: 02/13/2012 14:56:44 ******/

SET ANSI_NULLS...

I got the IT group to modify the Email's display name. I'll make due with that until they put up SS2k12. Thanks.

I'd like a free or greatly reduced copy of RedGate's Developer Toolkit....

Santa???

Mo,

The IT folks at a corporation have the job of supporting you, but first and foremost, of protecting corporate assets and intellectual property.

Many of them...

When I ran your T-SQL, I got a message set I've seen before:

Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.

Msg 5845, Level...

I do love Montreal. I have friends there. I speak a little French as well.

OK, let me start a new thread and maybe I can describe it better. I'd be overjoyed to simplify this group of queries.

Thanks, guys.

Ninja, where are you located? (Just...

Ninja's_RGR'us (11/22/2011)

---

JimS-Indy (11/22/2011)

---

Thanks for that catch. I'll fix it.

I'm currently stuck on a union query that's lockin up for some reason.

I am enjoying the learning, though.

Again, thanks for...