You can add the Application Name to the connection string for SQL Server so that it becomes easier to debug problems when you use a tool like SQL Profiler as it will be much easier to identify the commands being issued by your application.
For more information see Ben Hall‘s blog: SQL Connection – Application Name
Thanks for that – I’m sure I will find that very useful in the future!