Hi Andrew,

Thanks for the help.

By 'particular location' , do you mean clients expect WKS or SQL Server Browser service to be on port 1434 and they will not be...

No, I am not running SQL 2000 and SQL 2005 side by side. Actually, when we make a jdbc connection to a named intance of SQL 2005 with following connection...

Need a suggestion...

If the system time is equal to last modified timestamp of the trace file , then can we assume that the trace file is active?

This still does not solve my problem 🙁

This table does not have entry for the active trace file which has been generated using SQL Server Profiler.

I think SQL...

Well Krishna, This is not exactly what I am looking for.

Actually my problem is:

If only the path of a trace file is given to me and that trace file is...

Thanks Krishna.

But when I generate a trace file using SQL Sever Profiler, I don't get to know the trace id of that file.

Moreover , when I execute above command ,...