Identify your SQL Server applications (SQL Server 2000)

With ADO and ADO.NET, you can specify a Microsoft SQL Server application name by including it as one of the properties in the SQL connection string, like this:

...;Application Name=MyDbApp;...

When you do, you get the benefit of being able to see this value clearly shown in SQL Profiler traces. You can even perform filtering in your trace to narrow the information you have to examine to only what's relevant to your own application.