That query is being run 8000 times. What is the duration of the trace you are running?

The fact that is says .NET Sql Client is the application means someone...

If you have it in a group (details are a group) you can say Keep Together.

You need to get rid of the single-quotes and replace the @ with a :. Check out this blog post

What application are using to connect to SQL Server? Are you on a domain?

You can start with this article.

If you want to see the information in your trace you probably need to add sql:batch_starting and sql:batch_completed.

Another option would be creating a master server and creating the job there. Start with this BOL topic

Your issue is that the Blocked Process Report Event does not include the DatabaseName column, so you can't filter on it for that event. You need to use the...

The same reason you'd create an assembly for any development project, code re-use. You may have a need for some kind of custom conversion that will be used by...

According to this you should be able to.

I would agree with your preference. If you do everything locally and then push to the dev server you aren't stepping on each other's toes during development and unit...

Windows accounts. Running from a query window means it is running using the SQL Server Service account.

You can create a server group in SSMS (Registered Servers tab), right-click on the group and select new query. Then the query will be run against all the servers...

Sounds like you haven't setup the project configuration. See how here.

I'm not sure I understand what you need to do. Based on what you have provided you could be doing either of these 2 things: