When you have several .net applications or websites connecting to the same database, they all show up in SQL Profiler with the same Application Name ".Net SqlClient Data Provider". I just learned that you can add an Application Name property to the connection string so you can make a unique name for each application.
connectionString="Data Source=MyServer;Initial Catalog=MyDatabase;Persist Security Info=True;User ID=MyUserName;Password=MyPassword;Application Name=My Application"
Subscribe