Object Doesn't Exist Or You Lack Permissions In SQL Server (Naming)

Check out the solution in the video Cannot find the object sp_Name because it does not exist or you do not have permission (naming). While this error should rarely appear, it serves as a reminder to avoid using built-in Microsoft naming convention for your objects. It's not that it won't work, it's that you may see bugs in your code (like this case).

Naming convention gets people to argue because everyone feels like they have input. A mentor once shared with me that when people don't feel like they're an expert (or good) in an area, they love to argue about minutia because they can provide input on things that don't matter. As we see in this case, sometimes what appears to be minutia matters - sometimes, it doesn't.