You do realize that the addition of the new index requires space that might not have been available and that dropping the first NCI made a bunch of space available,...

EDIT: Looks like Steve posted while I was working on replies.  Leaving this reply here even though it overlaps with Steve's pose.

FOR and AFTER are identical in meaning.

https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql#arguments

You're trigger is...

From the article:

---

And most people rarely upgrade their OSS. They get something that works and don't want to change. I get that, as I feel the same way...

You can simplify the WHERE clause in AlphaNumericOnly and AlphaOnly by taking advantage of the fact that upper and lower case letters differ only by the 6th bit, which...

I'm a little late here but great observation, Anthony. I'll have to give that a try.

From the looks of things, MS hasn't done a good job on QA since 2017.

Does Example 7 of the following article do it for you?

https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

Does example #7 in the article at the following link do it for you?  You can add criteria to only consider stored procedures.

https://www.mssqltips.com/sqlservertip/2999/different-ways-to-find-sql-server-object-dependencies/

Tru dat!

That other post can be found at the following link...

https://www.sqlservercentral.com/forums/topic/tracing-a-performance-issue

Removed accidental dupe post.

There's been some good things since 17 hit the streets.  They did, however, break copy'n'paste.  I have a special color (Red) that I use for ALL constants and a special...

It's also going to miss any and all "whole dates" (a.k.a. dates with a midnight time) for the 3 years involved.  The > should have been >= in all 3...

Ya just gotta...

I believe the more common, and better, naming for tables is plural.  I can't think of a major relational dbms that uses singular system table names.

For example: sys.objects (SQL...