Re: Encrypted Stored Proc

From: L Gonzales (anonymous_at_discussions.microsoft.com)
Date: 11/09/04 

Date: Tue, 9 Nov 2004 08:30:01 -0800

Thank you.
>-----Original Message-----
>SELECT COUNT(*)
>FROM INFORMATION_SCHEMA.ROUTINES
>WHERE ROUTINE_DEFINITION IS NULL
>
>--
>Adam Machanic
>SQL Server MVP
>http://www.sqljunkies.com/weblog/amachanic
>--
>
>
>"L Gonzales" <anonymous@discussions.microsoft.com> wrote
in message
>news:53c601c4c674$043a6ba0$a301280a@phx.gbl...
>> Is there an easy way to identify how many stored procs
are
>> encrypted in a database?
>>
>> TIA.
>
>
>.
>

Relevant Pages

  • Re: Protecting database from administrators
    ... Regular users of the database can be secured by only allowing them access through an application, using stored procs, etc.. ... Mark Allison, SQL Server MVP ...
    (microsoft.public.sqlserver.security)
  • Re: Encrypted Stored Proc
    ... SQL Server MVP ... "L Gonzales" wrote in message ... > encrypted in a database? ... > TIA. ...
    (microsoft.public.sqlserver.programming)
  • Dynamic SQL in Stored Proc
    ... I have a database setup so that NO users have READ, ... Dynamic SQL and they have stopped working. ... error message when executing one of the stored procs. ...
    (microsoft.public.sqlserver.security)
  • Re: Database recovery with data file only
    ... Basically using that command breaks your business logic as there's no ... "Dan Guzman" wrote in message ... >> database Backup as well as ... >>> SQL Server MVP ...
    (microsoft.public.sqlserver.server)
  • Re: How critical is the transaction log file?
    ... Tibor Karaszi, SQL Server MVP ... file when you have only one file (no log file). ... circumstances it is supported to attach only an mdf file. ... > This development database that we're building does not have any 'user' ...
    (microsoft.public.sqlserver.tools)