>You may have already stated this and I missed it, but other strong arguments for stored procedures in SQL Server 7.0+ are: > >
The execution plan is compiled when the SP is created. A call to an SP need not be compiled. >
SP code is re-entrant. Subsequent calls to the same executing SP run faster. >
SPs allow you to hide the implementation from the interface. If the schema for the database changes, the SP can be changed without having to recode application logic. > >And there are others but it's Sunday and my head is murky :-)