How do I fire a sql statement from being seen by a trace sessi

try
select * from <table> -- sp_addlogin
and this statement will not be show in profiler
Aleksandar Grbic
MCDBA, Senior Database Administrator
"GregO" wrote:

> Hi Aleksandar,
> Can you give me an example of this. I don't really understand what you me
an
> kind regards
> Greg O
> "Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
> message news:FD863E94-89C2-45D3-B682-F7AA03E0C07C@.microsoft.com...
>
>Hi ,
Well I didn't know that worked. Anyway you can still find the SQL in
syscacheobjects
select * from dbo.syscacheobjects
kind regards
Greg O
Need to document your databases. Use the firs and still the best AGS SQL
Scribe
http://www.ag-software.com
"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
message news:055AE9C0-055A-4543-AFE4-BAD470D25771@.microsoft.com...
> try
> select * from <table> -- sp_addlogin
> and this statement will not be show in profiler
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "GregO" wrote:
>|||answer is:
Aleksandar Grbic
MCDBA, Senior Database Administrator
"GregO" wrote:
> Hi ,
> Well I didn't know that worked. Anyway you can still find the SQL in
> syscacheobjects
> select * from dbo.syscacheobjects
>
> --
> kind regards
> Greg O
> Need to document your databases. Use the firs and still the best AGS SQL
> Scribe
> http://www.ag-software.com
>
> "Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
> message news:055AE9C0-055A-4543-AFE4-BAD470D25771@.microsoft.com...
>
>|||Hi Aleksandar ,
Not disputing your post but being seen/traced can mean being seen (which it
can via syscacheobjects) or being traced
kind regards
Greg O
Need to document your databases. Use the firs and still the best AGS SQL
Scribe
http://www.ag-software.com
"Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
message news:E33A74C8-4BA6-4909-8D41-B828416B6C53@.microsoft.com...
> answer is:
>
> --
> Aleksandar Grbic
> MCDBA, Senior Database Administrator
>
> "GregO" wrote:
>|||;)
--
Aleksandar Grbic
MCDBA, Senior Database Administrator
"GregO" wrote:

> Hi Aleksandar ,
> Not disputing your post but being seen/traced can mean being seen (which i
t
> can via syscacheobjects) or being traced
>
> --
> kind regards
> Greg O
> Need to document your databases. Use the firs and still the best AGS SQL
> Scribe
> http://www.ag-software.com
> "Aleksandar Grbic" <AleksandarGrbic@.discussions.microsoft.com> wrote in
> message news:E33A74C8-4BA6-4909-8D41-B828416B6C53@.microsoft.com...
>
>