I have a stored procedure that contains many `SELECT` commands.

Instead of putting `OPTION (MAXDOP 8)` at the end of every select command, is there a way I can set it at the start of the stored procedure and remove it at the end, without actually setting it on the server?

ex.

```
sp_configure 'max degree of parallelism', 4
go
reconfigure with override

```