that is what we do but some lazy dba/developer always breaks the system so as to do it quick & easy; happens particularly when we work with a dba of a...

what stops a user editing a stored procedure via the properties menu in enterprise manager?

For the sake of code maintenance and the speed of writing it, object oriented languages like c#,c++,java merely require a persistant data store. Object databases &/or object APIs like jdo,odmg...

re speed:

With MS SQL Server, Microsoft will testify that a SP using temp tables and cursors will be most likely recompiled at execution time.  Cursors have a reputation for being slow.

re...