Hi

Does anyone know if it is possible to set the degree of parallelism for a specific Stored proc in SQL Server?

We are running SQL Server 2005 Enterprise Edition.

I'm having an issue all of a sudden with one SP coming up with a bad execution plan and want to see to I can force the SP to run on only once processor.

As another option how would I force a new plan to be generated for the SP?

Thanks

Gary