Glad you found it. I know that can be maddening.

I have no idea why proc fails and sql works. That's why I asked to check versions. I have had versions seem to rev underneath me. Building a second proc...

@jason

I do think EAV has a place, especially in the real world. We don't live in a perfect world, especially with regard to requirements/specifications and time. We do...

@Carlo P - I think my handling tends to be more consistent where if you have translations, you're a) putting one language ahead of others and b) means I need...

Something seems odd. Are you sure you have the same version of the proc code?

Maybe try this:
- Script the proc out
- change to a new name...

This might help: http://www.sqlservercentral.com/blogs/sqlrnnr/2018/11/26/ghosts-in-your-database/

I don't think this is parameters. Looking there likely is a distraction. I suspect there's a data error somewhere in a table, and I'm guessing that's where the issue is....

I don't see EAV as evil. They don't scale well and they can be problematic for busy workloads, but for an ad hoc item that you don't want to put...

How do you kick this off? Is a user doing this or does it need to trigger on some change in your existing database?

The designation of a file as .mdf or .ldf or .ndf is arbitrary and by convention. There isn't any reason you must have the files names with these extensions. I...

All transactions are replayed on the mirror, so log space is used. You have an alert on the DR server looking for the log being above 80%. Not sure what...

You should stop using SSMS for 208R2. Download SSMS 17.9, which is free and will work fine for SQL Server 2008 R2.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Second, I'm guessing you...