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 2000 Forums
 SQL Server Administration (2000)
 log remote QA/EM connections?

Author  Topic 

sql777
Constraint Violating Yak Guru

314 Posts

Posted - 2005-07-01 : 21:44:05
Hi,

Is it possible to log connections into a database server? ie. people using QA or EM remotely?

derrickleggett
Pointy Haired Yak DBA

4184 Posts

Posted - 2005-07-02 : 16:06:48
Yes. You can use Profiler or setup a trace for this. Look at the Security filters in Profiler. Try setting it up there, then ask us if you have questions. It's pretty straightforward.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.
Go to Top of Page
   

- Advertisement -