they didn't have a test database. Modifications made in Visual Studio and run through debugger on local PC had to connect to prod database because that was all you had.

I could never comprehend management thinking that allowed that setup.