Is it possible to get sql profiler for sql2008 for free or you have to have a license to get it?
i.e. it won't work with sql express
First. SQL Profiler does work with SQL Express. Second. You can get SQL Profiler with the Developer version of SQL, which is included with all MSDN licenses. However you will not be able to get it for free with SQL Express like you can with SSMS.