Excellent, this seems to do the trick..... just need to know the main version.

DECLARE @outvar varchar(8000)

EXECUTE master..xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\NET Framework Setup\NDP\v2.0.50727','Version',@outvar OUTPUT

PRINT @outvar

Thanks

Guys,

I had this issue not so long ago so I wrote this procedure which recompiles all of the stored procedures that the DBCC CHECKDB is complaining about, its probably no...