I have a sproc that does not compile in sql compare that is perfectly valid in SQL 2008. It uses this code following a query: OPTION (MAXDOP 1) Is this a problem and are there any workarounds?
Actually, I mean I have a set of script files I'm trying to compare to a database. In one of the scripts it has OPTION (MAXDOP 1) following an insert statement. When the initial parsing of the scripts happens, it is unable to parse this sproc.