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 Administartor 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.
>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?
TIA,
Willianto
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only