Can we Create Trigger on Stored Procedure in SQL Server 2008

Question

Post reply

Can we Create Trigger on Stored Procedure in SQL Server 2008

guptaprashant1982-1107326

SSC Veteran

Points: 204
More actions
July 29, 2011 at 1:15 pm

#245146

Can we Create Trigger on Stored Procedure in SQL Server 2008:-)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Ghanta Hall of Fame Points: 3999 More actions · Answer 1

CREATE PROC ...

AS

BEGIN

DECLARE @strSQL varchar(4000)

SET @strSQL = 'CREATE TRIGGER....'

exec (@strSQL)

END

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 2

Why do you want to do that? Triggers are supposed to be at table (or view) level, not only 1 statement. Why not keep going in the proc and add more steups?

Ghanta Hall of Fame Points: 3999 More actions · Answer 3

may be he is dynamically creating the table and using that table for other steps...

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 4

Ghanta (7/29/2011)
may be he is dynamically creating the table and using that table for other steps...

... stil not the correct way to code this if this is the case. 😉

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

guptaprashant1982-1107326 (7/29/2011)
Can we Create Trigger on Stored Procedure in SQL Server 2008:-)

Create a trigger on a stored proc or create a trigger in a stored proc?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass