SQL 7.0 / 2000 Profiler 1

[stnkyminky]

We've upgraded from 7.0 to 2000. Before the upgrade I could use Profiler to display connections as they occur.
Now, Profiler will only capture connections that existed before the trace started.

Thanks Scott
Programmer Analyst
<><

 

[jplaz]

exist in SQL Server Profiler one selection of &quot;existing connections&quot;

Use thisn for retrieve result of connection after of start the trace

Regards

 

[tlbroadbent]

In the Profiler Events tab, select Security Audit events &quot;Audit Login&quot; and possibly &quot;Audit Logout.&quot; Make sure you are not filtering to exclude logins.

If you select the SQLProfilerStandard template, it should have the appropriate events already selected.

jplaz,

&quot;Existing connections&quot; is the event that provides the list of connections that exist when the trace starts. This event doesn't show new connections or logins. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains &quot;Suggestions for Getting Quick and Appropriate Answers&quot; to your questions.