>Hi Kevin
>What if you want to switch the data to point to say Oracle or MySql?
>
>Bob
>

Stored Procedures take advantage of one of the fundamental advantages of a server-based database - data is processed on the server using the server's memory and only results sets are returned to the client saving network resources. This is a big deal on busy LANs, and a huge deal for web apps and web services.

Plan appropriately first so you don't have to switch to completely different data providors. Oracle and Microsoft SQL servers scale from workstation to enterprise seamlessly so there's no real compelling reason to switch. If planning was bad initially or a company just wants to spend lots of extra money, then they can go ahead and switch.