I am not sure what I did while installing SQL server express 2008 but sql profiler is not on my machine. is there a way to get that separately? my machine is not running on a server OS.
The Microsoft SQL Server profiler is only available with commercial versions of SQL Server. However, there are third party tools for helping to profile a SQL Server Express instance: