"Just D." <no@spam.please> wrote in message news:0NiSc.26288$Uh.6196@fed1read02...
> All,
>
> Should it work in MSSQL Server 2000?
>
> Just D.
>
> Description
> Hides the source text for the specified compiled object.
>
> Syntax
> sp_hidetext [objname [, tabname [, username]]]
>
> Parameters
> objname
>
> specifies the compiled object for which to hide the source text.
>
> tabname
>
> specifies the name of the table or view for which to hide the source text.
>
> username
>
> specifies the name of the user who owns the compiled object for which to
> hide the source text.
>
> Examples
> Example 1
>
> Hides the source text of all compiled objects in the current database:
>
> sp_hidetextExample 2
>
> Hides the source text of the user-defined stored procedure, sp_sort_table,
> that is owned by Mary:
>
> sp_hidetext @objname = "sp_sort_table", @username = "Mary"Example 3
>
> Hides the source text of the stored procedure pr_phone_list:
>
> sp_hidetext "pr_phone_list"Example 4
>
> Hides the source text of all check constraints, defaults, and triggers
> defined on the table my_tab:
>
> sp_hidetext @tabname = "my_tab"Example 5
>
> Hides the source text of the view my_vu and all check constraints, defaults,
> and triggers defined on the table my_tab:
>
> sp_hidetext "my_vu", "my_tab"Example 6
>
> Hides the source text of all compiled objects that are owned by Tom:
>
> sp_hidetext @username = "Tom"
>
>