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 Jalil

[Vikram A Punathambekar]

1. I'm sorry, I don't follow you. Are you trying to encrypt the contents of the database? If so, you can a) encrypt the contents before you store them in the database and/or b) restrict access to the database. 2. Yes, you can use stored procedures from C#. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbconintroductiontodatacommandobjectsinvisualstudio.asp looks useful. HTH. :) Cheers, Vikram.

---

"When I read in books about a "base class", I figured this was the class that was at the bottom of the inheritence tree. It's the "base", right? Like the base of a pyramid." - Marc Clifton.

[Colin Angus Mackay]

Abdul Jalil Mohamed wrote:

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:

can we populate the stored procedure from c#..

Yes, you can put your creation script in a SqlCommand object and ExecuteNonQuery() Does this help?

---

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

[ayuba asia]

how do we encrypt stored procedure an example will be gooo thanks fot the reply

[ayuba asia]

i'm trying t exncrypt the code inside stored procedure. so that when anyone open the stored procedure they can not read it or is the any where we can prevent the user from access the stored procedure even administratr cannt see the code..

[Colin Angus Mackay]

See the documentation for CREATE PROCEDURE[^]

---

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

[ayuba asia]

Thanks guys this really help me thanks a lot

[Russell Jones]

you can declare your SQL Stored procs using the WITH ENCRYPTION statement, this will encrypt them in SysComments and they should execute fine. I have never tried using this but i have it on good authority that it works. Using WMI for SQL server you should be able to create stored procedures; create a management object and the execute your SP text using it. HTH Russ