Showing posts with label event. Show all posts
Showing posts with label event. Show all posts

Wednesday, March 21, 2012

How to use SQL Profiler to capture Trigger of a particular table

as subject, i want to know capture Trigger of a particular table of a
database?
i don't know which event should i choose? Stored Procedures or TSQL? what
should i enter to Data Columns and Filters Tab?
thanks!
mullinHi,
Go for the event class : Stored procedure - SP:STMTCOMPLETED
what should i enter to Data Columns and Filters Tab?
Select the standard template and in event select only the Stored procedure -
SP:STMTCOMPLETED
--
Thanks
Hari
MCDBA
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:uzbmMDhTEHA.1764@.TK2MSFTNGP10.phx.gbl...
> as subject, i want to know capture Trigger of a particular table of a
> database?
> i don't know which event should i choose? Stored Procedures or TSQL? what
> should i enter to Data Columns and Filters Tab?
> thanks!
> mullin
>sql

How to use SQL Profiler to capture Trigger of a particular table

as subject, i want to know capture Trigger of a particular table of a
database?
i don't know which event should i choose? Stored Procedures or TSQL? what
should i enter to Data Columns and Filters Tab?
thanks!
mullin
Hi,
Go for the event class : Stored procedure - SP:STMTCOMPLETED
what should i enter to Data Columns and Filters Tab?
Select the standard template and in event select only the Stored procedure -
SP:STMTCOMPLETED
Thanks
Hari
MCDBA
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:uzbmMDhTEHA.1764@.TK2MSFTNGP10.phx.gbl...
> as subject, i want to know capture Trigger of a particular table of a
> database?
> i don't know which event should i choose? Stored Procedures or TSQL? what
> should i enter to Data Columns and Filters Tab?
> thanks!
> mullin
>

How to use SQL Profiler to capture Trigger of a particular table

as subject, i want to know capture Trigger of a particular table of a
database?
i don't know which event should i choose? Stored Procedures or TSQL? what
should i enter to Data Columns and Filters Tab?
thanks!
mullinHi,
Go for the event class : Stored procedure - SP:STMTCOMPLETED
what should i enter to Data Columns and Filters Tab?
Select the standard template and in event select only the Stored procedure -
SP:STMTCOMPLETED
Thanks
Hari
MCDBA
"Mullin Yu" <mullin_yu@.ctil.com> wrote in message
news:uzbmMDhTEHA.1764@.TK2MSFTNGP10.phx.gbl...
> as subject, i want to know capture Trigger of a particular table of a
> database?
> i don't know which event should i choose? Stored Procedures or TSQL? what
> should i enter to Data Columns and Filters Tab?
> thanks!
> mullin
>

how to use server time as an event

Hi, I want to do some data transfer from a network share and also run
some stored procedures.
How can I get them to run at a designated time, automatically?Hi

There are numerous ways to do this! You can use the SQL Server scheduler to
run a DTS package or other tasks, but the Windows Scheduler may also be
used.

Details on DTS can be found in Books online and there is a great resouce at
http://www.sqldts.com

John

"Hitcher" <steveChambers66@.hotmail.com> wrote in message
news:2f89f21f.0310220828.7ae813f9@.posting.google.c om...
> Hi, I want to do some data transfer from a network share and also run
> some stored procedures.
> How can I get them to run at a designated time, automatically?