Stored Procedure on a read-only AlwaysOn Availability Group replica We have a read-only reporting server that is part of the AlwaysOn availability group.   Our developer wants to create some stored procedures. My question is where should the stored procedure be created--will that be on the primary since the secondary is read only ?
A possible workaround would be; Just create a database in the secondary instance and then create the stored procedures accessing the data from the databases being replicated. 

EDIT: But this database wouldn't be replicated.