Question: where are sql server stored procedures stored?
Answer: The stored procedure are stored as named objects in the SQL Server Database Server. When you call a stored procedure for the first time, SQL Server creates an execution plan and stores it in the cache.