Heh... and the graphics I posted in a previous post certainly went south when they did the "improvements" for this site.  Lordy.

Heh... one does have to wonder though, why anyone would use a max data type (LOB) for such a thing. 🙂

Excellent.  Thanks for the feedback, Michael.

Excellent.  Thanks for the feedback, Bruin.  I think I can speak for the others in saying that we're very interested in how your test turns out.  My production system only...

To be honest, I think that all'y'all 😀 are making this a whole lot more complex than needed.  The PK on the table is an identity column.  That means that...

And, no... not as old as dirt.  I'm older than a lot of the dirt I made in my garden. 😀  I've got sox older than some of your adult...

Jeff,

Thanks for the link.  Now I understand how to obtain the return code.

Here is the only part I don't understand.  Using the code from my example, how might the...

Jeff,

Thanks for the link.  Now I understand how to obtain the return code.

Here is the only part I don't understand.  Using the code from my example, how might the...

IMHO, memory optimized tables have a lot of baggage for something like this.  How often will you need to do this?  If it's once every 10 minutes, maybe.  If it's...

You have to use RETURN somevalue or variable in the proc to get such a return.

See the following...

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/return-transact-sql?view=sql-server-ver15

Hi Jeff

that's incredibly fantastic. That's exactly what I thought.

The system views such as: sys.sql_dependencies goes in the right direction but the tool from Quest is a real hammer.

And the...

Maybe, but it shouldn't be for long unless you have a huge number of emails per day.  Of course, you would have had the same blocking (short and sweet) with...

I'm thinking that, although the mail items are being deleted, I'm not sure that any attachments will be and I'm pretty sure that the mail log isn't being reduced by...

Using 9999-01-01 is no more of kludge than using NULL but the former has advantages over using NULL when it comes to performance, especially if you understand that the use...

Cool.  Added the link to the Forum FAQ article to my signature line.  Thanks, Steve.