Getting .Net SqlClient Data Provider calls from redgate tool
I ran a trace, and during it had a coworker run a SQL Compare scan. He also has SQL Source Control installed. The SQL Compare showed up properly in the trace: (Red Gate Software - SQL Tools)
However, for the following call, the application name shows up as ".Net SqlClient Data Provider", which is the generic name SQL Server uses if there's nothing in the connection string.
Can I please get that changed so that it shows as "Red Gate Software - SQL Tools" too, please?
SELECT revisions.value AS Revision, scripts.value AS ScriptsLocation, migrations.value AS MigrationScriptsLocation FROM [ERXPAD].sys.extended_properties AS revisions JOIN [ERXPAD].sys.extended_properties AS migrations ON migrations.minor_id = revisions.major_id JOIN [ERXPAD].sys.extended_properties AS scripts ON revisions.minor_id = scripts.minor_id WHERE revisions.name = 'SQLSourceControl Database Revision' AND migrations.name = 'SQLSourceControl Migration Scripts Location' AND scripts.name = 'SQLSourceControl Scripts Location';