Why oh why do some developers not feel the need to version stored procedures ?
On a current project I have been watching a developer (who happens to be working on a different project to me) work. He seems like he knows what he is doing, and he is following a bunch of "best practices" like CVS and build tools. However, everytime he works on a stored procedure, it is inside Enterprise Manager!!!!!
Why is T-SQL code treated like a second class citizen by so many people ?. It is equally crucial to the workings of the system, and equally easy to introduce bugs into, yet some people don't see the need to treat it like real code.
I don't even buy the argument that it is easier. Enterprise Manager would have to be the WORST code editing environment in the world, well OK, there is Notepad but you get my point (Don't even get started on that Rob).
Anyone out there that edits stored proc code inside Enterprise Manager, please drop me a comment and tell me why. I'd love to hear a single good reason from the community.