Siphon Configuration
- Sunday, March 15th, 2009
- Comments (0)
- Articles
If you’re using connection strings on the web, set Application Name to the domain name. If you’re using connection strings with an executable, set Application Name to the executable name. If you have to use SQL Profiler to diagnose performance issues, it will be easier to filter out a specific application or web site.
<connectionStrings> <add name="LocalSqlServer" connectionString="... Application Name=mywebsite.com;" /> <add name="LocalSqlServer" connectionString="... Application Name=myapp.exe" /> </connectionStrings>
Here’s a fun way to waste 2 hours of your life. I was writing a custom config section, and trying to figure out why this wasn’t throwing a duplicate key error:
More…