Willianto,

>Hello Sergey,
>
>Thanks for your respond. I've been learning from your post all this time, but I think this is the first time you answer my post (can't complain, I'm not too active in the UT anyway --- but I think that'll change soon!)
>
>>Any user that has System Administrator role granted can view or access any DB.
>
>I see. Well, I have to go with encryption then. Do you have any alternatives so that the user cannot view the data? Better yet: the user cannot view the data structure.

No DBA would ever allow you to do that.

>
>>You can do that in Enterprise Manager (EM) by right clicking on DB and
>>selecting All Tasks - Generate Sql Script. You can also do it >programmaticaly with SQL-DMO using Script method of different objects. The
>>ExecuteImmediate method of SQL Server object can be used to to run the
>>script on the target server.
>
>But how can I call the script from my VFP apps?

As I explained before, you can use SQL-DMO.