Re: How to prevent queries showing up in Profiler?
From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 03/14/04
- Next message: Oscar: "SQL Server 2K connection is interrupted regularly, why ?"
- Previous message: Aaron Bertrand [MVP]: "Re: T-SQL : Unknown number of input parameters"
- In reply to: Ben Fidge: "How to prevent queries showing up in Profiler?"
- Next in thread: Tibor Karaszi: "Re: How to prevent queries showing up in Profiler?"
- Reply: Tibor Karaszi: "Re: How to prevent queries showing up in Profiler?"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 14 Mar 2004 13:35:47 -0600
Ben,
There isn't any way to to really do what your after. If they have access to
run profiler (or even a network monitor) they can see your code. You can
(and probably should) use stored procedures and use the with Encryption
option which can help. But that will not stop a dedicated hacker. You need
to protect yourself with a good copywrite policy.
Andrew J. Kelly SQL MVP
"Ben Fidge" <ben.fidge@btopenworld.com> wrote in message
news:O0r7e5eCEHA.3748@TK2MSFTNGP11.phx.gbl...
> How do you prevent or protect your custom queries executed from within a
> custom application (in this case a Delphi written app) from being
displayed
> by Profiler?
>
> Are there any special "SET ??? OFF" commands that instruct the Profiler
NOT
> to display SQL queries?
>
> Thanks
>
> Ben
>
>
- Next message: Oscar: "SQL Server 2K connection is interrupted regularly, why ?"
- Previous message: Aaron Bertrand [MVP]: "Re: T-SQL : Unknown number of input parameters"
- In reply to: Ben Fidge: "How to prevent queries showing up in Profiler?"
- Next in thread: Tibor Karaszi: "Re: How to prevent queries showing up in Profiler?"
- Reply: Tibor Karaszi: "Re: How to prevent queries showing up in Profiler?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
