Parag,
No, the sync designer available in VS 2008 is only for client-server scenarios. The peer to peer provider still in early CTP thus it was not possible to support it with VS 2008.
Sync Designer will write the triggers and add tracking columns for you. It will also use SqlSyncAdapterBuilder to generate the sync commands. The commands will be stored in the application and not compiled as SP.
Thanks