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.
| Author |
Topic |
|
compprof
Starting Member
4 Posts |
 Posted - 2004-11-03 : 05:18:54
|
| Hi Is there a way to develop handlers for T-SQL statements? i.e. When the client issues a T-SQL statement (for instance, to create a stored procedure or a view, etc.), my handler at the SQL server side should receive this T-SQL statement first. Please let me know if there is a way to create this type of handlers at server side.Thanks |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2004-11-03 : 06:26:03
|
| What is the client ?QA, EM or a custom applicationrockmoose |
 |
|
|
compprof
Starting Member
4 Posts |
Posted - 2004-11-04 : 00:47:39
|
| The client could be any of QA, EM or client application. Thanks |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-04 : 05:32:33
|
| Sounds like you want something similar to triggers on system tables which aren't available.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-11-04 : 09:29:18
|
| Explain what you are trying to do, give some examples of ideally what you are looking for. Are you trying to implement security of some sort (i.e., row-based security)- Jeff |
|
|
|
compprof
Starting Member
4 Posts |
Posted - 2004-11-05 : 06:22:08
|
| Exactly, I would like to encrypt the stored procedures, but I don't want to use Microsoft's Encryption since it is weak. Hence, when a stored procedure is created using CREATE PROC (irrespective from which ever tool or appln the T-SQL comes from), I would like to write a hook (handler) at the server, which will encrypt the stored procedure before the stored procedure is stored in the sysobjects/syscomments table by the SQL server. Similarly, when the stored procedure is accessed using EXECUTE statement, my handler has to get invoked which will decrypt it and get it executed.Is there a way to do this? Thanks |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-05 : 07:45:45
|
| You might want to take a look at this product:http://www.sql-shield.com/Don't ask me how it works, but they also have (pretty severe) limitations:http://www.sql-shield.com/example.htmlI don't think you'd be able to get your handler function to work as you describe, without substantially rewriting the SQL Server executable. It will require more than just a hook into the encryption module. |
|
|
|
|
|
|
|
|
Reg. handlers for T-SQL