Solved

Passing the ApplicationName to SQL Profiler / C2 Auditing

Posted on 2006-11-10
2
813 Views
Last Modified: 2008-02-01
In a trace file, there is an "application name" field.  It displays "Query Analyzer", "SQL EM", or "Visual Basic", ".Net SQLClient Provider", etc.

We have applications that use Visual Basic 6.0 and ASP.NET.  I'm trying to figure out how to pass a name we decide on ("Application X") to the Trace/Audit file so that it shows up in the Application Name Field through both of them.

0
Comment
Question by:JaffaKREE
  • 2
2 Comments
 
LVL 16

Accepted Solution

by:
Hillwaaa earned 500 total points
ID: 17918698
Hi JaffaKREE,

There is a post on the msdn forums that indicates:

"The name normally comes from the the connection string:
server=MyServer;database=MyDatabase;Integrated Security=SSPI;Application Name=ApplicationName;"

Original post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=819752&SiteID=1

Cheers!
0
 
LVL 16

Expert Comment

by:Hillwaaa
ID: 17945685
Hi JaffaKREE - how did you go after setting the application name?
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

790 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question