Profiler: Seven words you can never use in a script?

28 Apr 2006 2:23 PM

kevin

using Sql Server 2K...
I have no idea if there are only seven, but apparently one of Profiler's
list of banned words is 'encryption'.

profiler displays the following message when it encounters a sp with the
word 'encryption' in the text of the object. It is within a comment block.

Can I turn this silly behavior off. After all you have to be sysadmin to run
profiler.

The message in the Text column was
-- 'encryption' was found in the text of this event.
-- The text has been replaced with this comment for security reasons.

kevin...

28 Apr 2006 5:45 PM

Michael Hotek

No, you have to be a sysadmin to define and execute a trace in SQL Server
2000. You do NOT have to be a sysadmin to open up a trace file and view it
in Profiler. So, this is a security measure within Profiler. No, you can
not turn it off.

--
Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

Show quote

"kevin" <ke***@discussions.microsoft.com> wrote in message
news:149EEF72-0FE8-43AC-A765-4BEC0486EC99@microsoft.com...
> using Sql Server 2K...
> I have no idea if there are only seven, but apparently one of Profiler's
> list of banned words is 'encryption'.
>
> profiler displays the following message when it encounters a sp with the
> word 'encryption' in the text of the object. It is within a comment
> block.
>
> Can I turn this silly behavior off. After all you have to be sysadmin to
> run
> profiler.
>
> The message in the Text column was
> -- 'encryption' was found in the text of this event.
> -- The text has been replaced with this comment for security reasons.
>
> kevin...

20 Jun 2006 12:33 PM

Andrea B.

Take a look at this tool for some explanations and a possibile solution:

http://www.andreabertolotto.net/Articles/SP4BlacklistedWordsRemover.aspx

Hope this helps!

Show quote

"kevin" wrote:

> using Sql Server 2K...
> I have no idea if there are only seven, but apparently one of Profiler's
> list of banned words is 'encryption'.
>
> profiler displays the following message when it encounters a sp with the
> word 'encryption' in the text of the object. It is within a comment block.
>
> Can I turn this silly behavior off. After all you have to be sysadmin to run
> profiler.
>
> The message in the Text column was
> -- 'encryption' was found in the text of this event.
> -- The text has been replaced with this comment for security reasons.
>
> kevin...