Discussion in 'T-SQL Performance Tuning for Developers' started by zhenyuanDeng, Sep 28, 2008.
Can event profile capture sql statements when using oledb interface?
i captured sql statments using sql profiler with client applications connected with sql server using oledb.
Can SQL SERVER 2000 do that?
version: developer edition sp4
No, unless I am mistaken this was added in SQL Server 2005, I'm afraid
I have never use SQL SERVER 2005, but i find that SQL SERVER 2000 can capture the statements when using oledb interface as moh_hassan20 said.
but when i use the statement such as "select * from XXX", event profile will capture some statement like:
declare @P1 int
declare @P2 int
declare @P3 int
declare @P4 int
exec sp_cursoropen @P1 output, N'select * from XXX', @P2 output, @P3 output, @P4 output
select @P1, @P2, @P3, @P4
I can capture the statement and the execution plan.
I would like to capture sql statements before execution, can we do that?
I was tried with SMO object, but it capture only that instance, i wanted to capture all the sql statement which comming from other applications.
any help is appriciated.
Separate names with a comma.