Check Sql Before Execute

Hello,
I like to know if there are way's to Get aSql sentences
there are sent to the SqlServer2000 and to check them
before Execute, and could to Change them (like add them
more parts to the WHERE ).
thank's
Eran."Eran A" <eran_@.walla.co.il> wrote in message
news:095001c3c96a$1c7ff4d0$a401280a@.phx.gbl...

quote:

---

> I like to know if there are way's to Get aSql sentences
> there are sent to the SqlServer2000 and to check them
> before Execute, and could to Change them (like add them
> more parts to the WHERE ).

---

You could use SQL Profiler to capture the SQL as it is being sent for
processing, and modify it. To my knowledge there is no way to capture SQL
"real time" (outside of a stored procedure execution stream), modify it,
then send it on it's way before it executes.
What is it you need to do?
Steve|||hi,
I want to concate string to the Sql before execute, to
force aApplication Sequrity & to remove Sql that are not
supposed to Run . (like RLS ability in Oracle)

quote:

---

>--Original Message--
>"Eran A" <eran_@.walla.co.il> wrote in message
>news:095001c3c96a$1c7ff4d0$a401280a@.phx.gbl...
>You could use SQL Profiler to capture the SQL as it is

---

being sent for

quote:

---

>processing, and modify it. To my knowledge there is no

---

way to capture SQL

quote:

---

>"real time" (outside of a stored procedure execution

---

stream), modify it,

quote:

---

>then send it on it's way before it executes.
>What is it you need to do?
>Steve
>
>.
>

---