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 |
|
Swati Jain
Posting Yak Master
139 Posts |
 Posted - 2007-06-27 : 10:34:59
|
| How I can run a script for creating stored proc on firing of trigger |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-27 : 10:37:29
|
| Why do you want to do this?Do you think you will have full control over it?MadhivananFailing to plan is Planning to fail |
 |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2007-06-27 : 11:16:01
|
| Yikes! that is the perhaps WORST idea I have ever heard of... Why the heck would you want to do this???? Can you explain WHAT you are trying to do, I am sure we can give you a much easier, simpler solution. I can only assure you that what you are trying to do is a really, really bad idea.- Jeffhttp://weblogs.sqlteam.com/JeffS |
|
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-06-27 : 11:16:15
|
| I'll say it again. The CREATE TRIGGER command should be disabled by default within SQL Server. Only DBAs with a requisite number of years of experience should be granted the passcode to unlock it.e4 d5 xd5 Nf6 |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-06-27 : 16:16:54
|
wow. why not take it a step further and have your trigger create other triggers?
elsasoft.org |
|
|
|
Swati Jain
Posting Yak Master
139 Posts |
Posted - 2007-06-28 : 03:25:31
|
quote:
Originally posted by jsmith8858
Yikes! that is the perhaps WORST idea I have ever heard of... Why the heck would you want to do this???? Can you explain WHAT you are trying to do, I am sure we can give you a much easier, simpler solution. I can only assure you that what you are trying to do is a really, really bad idea.- Jeffhttp://weblogs.sqlteam.com/JeffS
Hi Smith, Can you give me the easier and simpler solution for this?Swati |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-06-28 : 03:27:50
|
quote:
Originally posted by Swati Jain
quote:
Originally posted by jsmith8858
Yikes! that is the perhaps WORST idea I have ever heard of... Why the heck would you want to do this???? Can you explain WHAT you are trying to do, I am sure we can give you a much easier, simpler solution. I can only assure you that what you are trying to do is a really, really bad idea.- Jeffhttp://weblogs.sqlteam.com/JeffS
Hi Smith, Can you give me the easier and simpler solution for this?Swati
Can you explain what you are actually want to do by creating procedure dynamically?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Creating stored procedure dynamicaly.