pamsauto
asked on
MS SQL syntax question
What is the correct syntax for this SP? I want to create a SP to recreate some triggers in a DB. Here is what I have tried.
CREATE PROCEDURE dbo.CreateTriggersInPL2DB
AS
create TRIGGER PL2Enhancement_addEbayAuct
ON POWERLINK.dbo.INVENTORY
FOR insert
AS
insert into PLEnhancements.dbo.ebayLis
(
InventoryID,
CreatedOn,
ActionToPerform,
Status
)
select
inventoryID,
getdate(),
'addItem',
null
from inserted
Create TRIGGER PL2Enhancement_addProductT
ON dbo.INVENTORY
FOR insert
AS
declare @inventoryID int
select @InventoryID=inventoryid from inserted
exec PLEnhancements.dbo.InsertP
RETURN
CREATE PROCEDURE dbo.CreateTriggersInPL2DB
AS
create TRIGGER PL2Enhancement_addEbayAuct
ON POWERLINK.dbo.INVENTORY
FOR insert
AS
insert into PLEnhancements.dbo.ebayLis
(
InventoryID,
CreatedOn,
ActionToPerform,
Status
)
select
inventoryID,
getdate(),
'addItem',
null
from inserted
Create TRIGGER PL2Enhancement_addProductT
ON dbo.INVENTORY
FOR insert
AS
declare @inventoryID int
select @InventoryID=inventoryid from inserted
exec PLEnhancements.dbo.InsertP
RETURN
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ptjcb
Why are you trying to do this within a stored procedure? Why not just script the triggers? Are you planning to run this stored procedure often?