Praveena,
SQL Server Profiler was enhanced in SQL 2000. Some functionality was also
enhanced. You can use for example the stored procedure
Checkout
Creating and Managing Traces and Templates
http://search.microsoft.com/gomsuri.asp?n=1&c=rp_Results&target=http:....
microsoft.com/library/en-us/adminsql/ad_mon_perf_227n.asp
Reinaldo Kibel
Microsoft? Corp. - SQL Server Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use. ? 2002 Microsoft Corporation. All rights
reserved.
Additional support can be obtained at http://support.microsoft.com
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Content-Class: urn:content-classes:message
| Subject: RE: Unable to run Profiler definitions in SQL Server 2000
| Date: Mon, 7 Jan 2002 13:51:52 -0800
| Lines: 56
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
| Thread-Index: AcGXxYRfmTGWb59BRLqTwGVyBGmPUA==
| Newsgroups: microsoft.public.sqlserver.server
| NNTP-Posting-Host: TKMSFTNGXA09 10.201.226.37
| Path: cpmsftngxa07!cpmsftngxa10!cpmsftngxa09
| Xref: cpmsftngxa07 microsoft.public.sqlserver.server:189318
| X-Tomcat-NG: microsoft.public.sqlserver.server
|
| Thank you, David.
| But, is this the only way to do it in SQL Server 2000? In
| SQL 7, we were able to directly run a trace(without having
| to create a new trace and once again specify the name of
| the table to which it should be saved, though it is
| already a part of the definiton) by just choosing the
| Trace definition.
| This way, we have to specify the table to which the output
| needs to be saved, each time, even though it is a part of
| the trace template itself.
| Thank you,
| -Praveena
|
|
|
Quote:| >-----Original Message-----
| >Praveena,
| >
| >Will the following work for you?
| >
| >1) Open SQL 2000 Profiler.
| >2)From the "File" menu select "New" then "Trace".
| >3) A dialog will appear that will ask you which server
| you would like to
| >connect to.
| >4) Once you have connected to the server you what to
| trace, a "Trace
| >Properties" dialog will appear.
| >5) The "Trace Properties" dialog has a field
| titled "Template file name"
| >with a button with folder icon which will let you
| navigate to and select
| >the trace definition file that you would like to use.
| >
| >Thank you,
| >David
| >
| >David S. Patching
| >Microsoft Support
| >
| >
| >This posting is provided "AS IS" with no warranties, and
| confers no rights.
| >
| >Are you secure? For information about the Strategic
| Technology Protection
| >Program and to order your FREE Security Tool Kit, please
| visit
| ><http://www.microsoft.com/security>.
| >
| >
| >
| >
| >
| >.
| >
|
by