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 |
|
sudha12345
Starting Member
47 Posts |
 Posted - 2009-06-11 : 01:04:43
|
| From which Table the value for the function APP_NAME() is retrivedSudhakar |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-11 : 02:55:28
|
app_name() is fetched from the connection string, not a table.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
sudha12345
Starting Member
47 Posts |
Posted - 2009-06-11 : 03:30:35
|
| Can the default name will be changed (to set user defined name) not o Display the defaultSudhakar |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-06-11 : 03:43:43
|
Yes. Change your connection string.Include "Application Name=MyApplicationNameHere;"It works for SSMS too. Go to Connect -> Options and change to Additional Connection Parameters tab.
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Retriving value for the function APP_NAME()