Hi Micheal

Thank for replying

i think you dont understand what i'm saying... let say...uninstall sql server or stop the service manager .... i can copy the database files to another computer with sql server installed and attach the database files i can see all the sp,data,,,, in it...hope you understand



>Yes. Access control is one of SQL Server's strengths. A user must go through many layers before access to the data is allows: authentication to the server, access to the database, and then access to the data. This can be controlled to the column level if you'd like.
>
>Check out the section Managing Security in the BOL.
>
>-Mike
>
>>Hi All,
>>
>>Is there anyway I can protect my database from being view,
>>example store procedure, table or anything....., for distribution purpose
>>
>>Thanks