Stored Procedure

[ayuba asia]

I have a application that has is develop using c# B4 this all my data processing is done thourgh the tsql statment, now i want to switch the thing to stored procedure.. 1.) but my management wnt to know is they any way we can hide the code in stored from the database administrator like the 1 in the trigger where we can encrypt the trigger.. 2.) one more thing can we populate the stored procedure from c#.. so every update i will create 1 EXE for them to run and i will update the stored procedure without using any sql util... thanks... Jalil

[Colin Angus Mackay]

Abdul Jalil Mohamed wrote:

is they any way we can hide the code in stored from the database administrator like the 1 in the trigger where we can encrypt the trigger..

Yes, you can encrypt stored procedures

Abdul Jalil Mohamed wrote:

i will create 1 EXE for them to run and i will update the stored procedure without using any sql util

Yes, you can create an exe that runs SQL against the database. You can do this by using the SqlCommand object in a .NET application and then ExecuteNonQuery() I have an example on my blog where the SQL Script is stored as a resource inside an EXE file then run against the database. You might find it useful: http://blogs.wdevs.com/colinangusmackay/archive/2004/10/15/857.aspx[^]

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[Daniel Santillanes]

1.) use WITH ENCRYPTION statement before AS --Stored procedure statements Do make sure to have a backup of the stored procedure somewhere since, you're not going to see that text once you applay the statement and close the editor. 2.) you can... create stored procedures from C#... theoretically yes, you can execute a SQL command with a CREATE PROCEDURE statement, and then use the SP. daniero

[Colin Angus Mackay]

daniero wrote:

theoretically yes

It is not a theory, it is a fact. You can do this so long as you log on to the database as a user with ddl_admin, db_onwer or sysadmin privileges.

---

My: Blog | Photos "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucious

[Daniel Santillanes]

Thanks for clearing that up. I need to write it down :doh: :). daniero