G'man

SQL Server 2005 Tracing Question

Does anyone know how I can trace using the database ID in sql profiler (sql 2005)?

I normally have the following:-

<add key="strConnectionString" value="Server=server\sql2005;Database=Testdev;User ID=test;Password=test;Application Name=Test"/>

And use the Application name to profile with, but when you add a sql Datasource,  it adds a connection string to your web.config (vs 2005), sadly there is no application name part of the connection string allowed.

I suppose I should use NTUsername but I liked to use Application Name in the past.

Any thoughts on this?

Cheers
G

Print posted @ Thursday, January 25, 2007 3:46 PM