[dba-SQLServer] Job Change, and a Question

Stuart McLachlan stuart at lexacorp.com.pg
Sun Nov 12 15:59:38 CST 2006


On 13 Nov 2006 at 8:54, Michael Maddison wrote:

> Another argument to use sprocs is that  you the dba can then optimise
> the SQL within without
> recompiling the exe/dll's of the app.

Not just the SQL,  you can change the database itself if you need to 
without breaking the exe,  the FE doesn't need to know anything abou how 
the BE is structured  as long as the sprocs still work the same.

-- 
Stuart





More information about the dba-SQLServer mailing list