Hi
I have created a stored procedure that create a trace on SQL 7 and start
the trace. but this procedure is sending the trace to a file. I want to send
the output of trace to a table.
I am using xp_trace_setqueuedestination and specified the proper destination
table, but still I am not able to get the data in the table.
After some research I find out that I have to xp_trace_generate_event.
But I don't know how to use xp_trace_generate_event to generate the output
to a trace table.
Can someone help in doing this?
Or is there some undocumented stored procedure like sp_trace_getdata that
exist in SQL 2000.
Thanks in advance.
Pushkar
It's hard to say without seeing what you are specifying for
xp_trace_setqueuedestination but try to qualify the table
for the table parameter, e.g. 'YourDB..YourTable'
Make sure you are using 4 for the destination parameter.
-Sue
On Wed, 8 Jun 2005 16:01:48 +0530, "Pushkar"
<tiwaripushkar@.yahoo.co.in> wrote:
>Hi
>I have created a stored procedure that create a trace on SQL 7 and start
>the trace. but this procedure is sending the trace to a file. I want to send
>the output of trace to a table.
>I am using xp_trace_setqueuedestination and specified the proper destination
>table, but still I am not able to get the data in the table.
>After some research I find out that I have to xp_trace_generate_event.
>But I don't know how to use xp_trace_generate_event to generate the output
>to a trace table.
>Can someone help in doing this?
>Or is there some undocumented stored procedure like sp_trace_getdata that
>exist in SQL 2000.
>Thanks in advance.
>Pushkar
>
|||Hi
Below is the script I am using:
-- Create a Queue
declare @.rc int
declare @.QueueHandle int
exec @.rc = xp_trace_addnewqueue 1000, 5000, 95, 90, 67354401, @.QueueHandle
output
if (@.rc != 0) goto error
-- Set the events
-- SQL Server 2000 specific events will not be scripted
exec xp_trace_seteventclassrequired @.QueueHandle, 10, 1
exec xp_trace_seteventclassrequired @.QueueHandle, 12, 1
exec xp_trace_seteventclassrequired @.QueueHandle, 14, 1
exec xp_trace_seteventclassrequired @.QueueHandle, 15, 1
exec xp_trace_seteventclassrequired @.QueueHandle, 17, 1
-- Set the Filters
exec xp_trace_setappfilter @.QueueHandle, N'', N'SQL Profiler'
-- set the destinations
exec xp_trace_setqueuedestination @.QueueHandle, 4, 1,
N'sql-nt4',N'[master]..[Untitled - 1]'
-- save the definition in the registry
exec xp_trace_savequeuedefinition @.QueueHandle, N'Untitled - 1', 1
-- display queue handle for future references
select QueueHandle=@.QueueHandle
goto finish
error:
select ErrorCode=@.rc
finish:
go
Please suggest what changes in script should I do to get the trace result in
the table.
Thanks
Pushkar
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:t0pda1dnmf5raf844u5laj2ct4iaooktvm@.4ax.com... [vbcol=seagreen]
> It's hard to say without seeing what you are specifying for
> xp_trace_setqueuedestination but try to qualify the table
> for the table parameter, e.g. 'YourDB..YourTable'
> Make sure you are using 4 for the destination parameter.
> -Sue
> On Wed, 8 Jun 2005 16:01:48 +0530, "Pushkar"
> <tiwaripushkar@.yahoo.co.in> wrote:
send[vbcol=seagreen]
destination[vbcol=seagreen]
output
>
Showing posts with label trace. Show all posts
Showing posts with label trace. Show all posts
Wednesday, March 28, 2012
Friday, March 23, 2012
How to use SQL 2000 Profiler to create a trace for MSDE?
I have access to a SQL Server 2000 install, and need to write a trace
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
Marco
You should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||The trace templates for the profiler GUI is for the GUI only. What you need to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly could have been taken
straight from the template.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
sql
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
Marco
You should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||The trace templates for the profiler GUI is for the GUI only. What you need to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly could have been taken
straight from the template.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
sql
Wednesday, March 21, 2012
How to use SQL 2000 Profiler to create a trace for MSDE?
I have access to a SQL Server 2000 install, and need to write a trace
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
Marco
You should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||The trace templates for the profiler GUI is for the GUI only. What you need to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly could have been taken
straight from the template.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
sql
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
Marco
You should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||The trace templates for the profiler GUI is for the GUI only. What you need to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly could have been taken
straight from the template.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>
|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
sql
How to use SQL 2000 Profiler to create a trace for MSDE?
I have access to a SQL Server 2000 install, and need to write a trace
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
MarcoYou should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||The trace templates for the profiler GUI is for the GUI only. What you need
to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly
could have been taken
straight from the template.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gb
l...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
MarcoYou should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||The trace templates for the profiler GUI is for the GUI only. What you need
to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly
could have been taken
straight from the template.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gb
l...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
How to use SQL 2000 Profiler to create a trace for MSDE?
I have access to a SQL Server 2000 install, and need to write a trace
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
MarcoYou should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||The trace templates for the profiler GUI is for the GUI only. What you need to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly could have been taken
straight from the template.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
template to run against a MSDE install.
The trace template seems to be in binary format. Do I need to edit it to
bring it over to the MSDE box to run it there?
How would it be called from MSDE (using osql no doubt)?
MarcoYou should be able to run the trace commands from tsql. To do this enable
the profiler to be logged and view the commands it uses. Then run these in
MSDE and log to a file.
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message
news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||The trace templates for the profiler GUI is for the GUI only. What you need to do is to script a
running (, paused or stopped) trace from the GUI, where that trace possibly could have been taken
straight from the template.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Marco Shaw" <marco@.Znbnet.nb.ca> wrote in message news:Oh1CxtZ4GHA.4976@.TK2MSFTNGP06.phx.gbl...
>I have access to a SQL Server 2000 install, and need to write a trace
> template to run against a MSDE install.
> The trace template seems to be in binary format. Do I need to edit it to
> bring it over to the MSDE box to run it there?
> How would it be called from MSDE (using osql no doubt)?
> Marco
>|||On Tue, 26 Sep 2006 15:41:53 -0300, "Marco Shaw" <marco@.Znbnet.nb.ca>
wrote:
>I have access to a SQL Server 2000 install, and need to write a trace
>template to run against a MSDE install.
>The trace template seems to be in binary format. Do I need to edit it to
>bring it over to the MSDE box to run it there?
>How would it be called from MSDE (using osql no doubt)?
Can run the scripts in osql or query analyzer for MSDE, same as for
the larger versions, AFAIK.
J.
Subscribe to:
Posts (Atom)