Read SP source code from VB

Hi,
I'm developing an application to crypt SQL databases and i need to
read SP and Views source code from VB6, if you know how to do this
please answer me.

Greetings."Carpi" <carlos.rodriguez@.sparks-software.com> wrote in message
news:5280f320.0401080621.514fd41f@.posting.google.c om...
> Hi,
> I'm developing an application to crypt SQL databases and i need to
> read SP and Views source code from VB6, if you know how to do this
> please answer me.
> Greetings.

Probably the best place to start is the .Script method of the SQLDMO
objects, which will generate the CREATE statements for all object types.

Simon

Read only user and not seeing Tables, views etc

I would like to be able to setup a user that can only select information
from a View.
But when I enable security for this user, the user can see all the
tables, Views, Store Proc etc. I know it is only the names, but I don't
want the user to be able to do this, as he is only allowed to view the
view I have enabled for him.
The user can log in using Enterprise Manager and flick through the
tables, views etc, but can't read them, but he can get the names which
is what I don't want to happen.
Is there anyway of stopping the user from seeing all the other
information?
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!Hi,
In Enterprise manager you cant control that.
Thanks
Hari
MCDBA
"Bryan Avery" <b_avery@.yahoo.com> wrote in message
news:ObOG040BEHA.892@.TK2MSFTNGP09.phx.gbl...
> I would like to be able to setup a user that can only select information
> from a View.
> But when I enable security for this user, the user can see all the
> tables, Views, Store Proc etc. I know it is only the names, but I don't
> want the user to be able to do this, as he is only allowed to view the
> view I have enabled for him.
> The user can log in using Enterprise Manager and flick through the
> tables, views etc, but can't read them, but he can get the names which
> is what I don't want to happen.
> Is there anyway of stopping the user from seeing all the other
> information?
>
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!

Re : Restore table from Transaction Log

Hi,
After I copied some views from other database, I lost all records in five
tables. Unfortunely, I didn't have the backup file.
I tried to use Lumigent to restore from the Transaction log, and three of
them have been recovered successfully. But still have two tables cannot
restore.
Anyone can share some ideas how to restore the rest two.
Many many many thanks!Hi
Copying views will not delete data or drop tables, I can only assume that
you have scripted the view and it's dependent objects from Enterprise
Manager. In which case I think you should be able to restore all the tables
using the Lumigent product.
Failing that, as you don't have a backup, then the tables must be on the
system you scripted the view from.
John
"Bevis" wrote:

> Hi,
> After I copied some views from other database, I lost all records in five
> tables. Unfortunely, I didn't have the backup file.
> I tried to use Lumigent to restore from the Transaction log, and three of
> them have been recovered successfully. But still have two tables cannot
> restore.
> Anyone can share some ideas how to restore the rest two.
> Many many many thanks!
>
>