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