Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jveliz
Starting Member
1 Post |
 Posted - 2003-06-05 : 16:53:40
|
| HelloI want to know what application is inserting data in a table, I want to do that with a trigger but I don't know how to get the app nameThanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-05 : 16:57:08
|
| Well your application would have to tell you this. Your application would have to send this as well as the data to insert.Tara |
 |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-06-05 : 17:27:52
|
| You can use the APP_NAME() function assuming the application sets it's name in it's connection string.HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-06-05 : 17:29:49
|
| I wish it were a requirement for the application name to be set in the connection string. It is a very handy thing when running SQL Profiler or looking at sysprocesses.Tara |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-06-06 : 09:13:50
|
| I wonder, do the majority of applications not use connection pooling..for example, I know that a paricular login is because of the app...it's the only one it uses...I then have "application" level security built in to the db...Just curious...love to hear any comments..Brett8-) |
|
|
|
|
|
|
How to know the application name