Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Distribute SQL Database without users seeing SP's and Tables

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-19 : 07:50:06
Angus writes "Here's my situation.
I developed an application in VB and with MS SQL Server 7/2000. Now I want to distribute the application and the database on my website for trial purposes. The database contains many tables, stored procedures and lots of hard work. The thing is, I don't want anyone looking at the code for the stored procedures and the tables too. Even if I encrypt the sp's, people can see them with Profile. And the data can be played with, copied structurally and even allowing other applications to replace mine but using the same database. Plus I don't want to take over the SA user either... Basically, I want full control.
Is this possible or is there anything I can do get closer to what I want? Your help is appreciated.
Angus"
   

- Advertisement -