Just set up a TFS SQL 2008 Server project and imported my database and everything builds and seems to work (Used TFS to import the database). I want to user SQL Compare to compare the differences between the database and TFS and create deployment scripts but I'm seeing a lot of "noise" like
TFS does not have the "Grant Execute On.." but SQL Compare does
TFS does not have lines such as "Set Quoted_Identifier OFF" but SQl Compare does.
TFS does not like or allow (as far as I can tell) these sql commands; is there a way to filter them out?