Application ID - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Application ID

Author

Topic

balakrishnachow
Starting Member

24 Posts

Posted - 2010-10-19 : 15:14:24

Hi,

I Am new to sqlserverdba.i need to know what are all the applcations are connect to sqlserver? is there any id for that application which have connect to sqlserver?if id is there for that application can you tell me how we will find that id(i heard that for ever apllication they id which is connect to sqlserver).

Thanks,
Balakrishna.B

good

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-19 : 15:15:23

You can check this type of information via sysprocesses/sp_who/sp_who2/SQL Profiler/server-side trace.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

balakrishnachow
Starting Member

24 Posts

Posted - 2010-10-19 : 15:25:52

thanks tera...........

and any id for that applications it is giving in the trace......

thanks
Balakrishna.B

good

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-19 : 15:27:03

If the application is setting its name in the connection string, then that information is available in the trace via the ApplicationName column.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

balakrishnachow
Starting Member

24 Posts

Posted - 2010-10-19 : 15:30:02

oh...great

thanks tera.

thanks
Balakrishna.B

good

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-10-19 : 15:34:11

You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources