>I have a msdn subscription
>no I want to explore using sqlserver with my vfp9.2 and I am wondering which SQLserver i should download
>win7/64

The answer would probably depend on what, exactly, you are 'exploring'. If you are doing this with a view to using SQLServer for your clients application then try the simplest version which would fulfill their needs,

CE.....
SQL Express
SQL 2008 (or, as Bill? suggested 2012)......

If that is not your criteria then what is ?