sp_executesql

Question

Viewing post 1 (of 2 total)

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

Jack Corbett SSC Guru Points: 184395 More actions · Answer 1

I think you need this:

SET @SQLString = N'spiTriggerControl';

to be this:

SET @SQLString = N'Exec spiTriggerControl';

I'm not sure why you are using sp_executesql based on the information you have provided. You could just do:

DECLARE @Trig_ID_Out VARCHAR(10);

Exec spiTriggerControl @Trig_ID_Out OUTPUT;

SELECT @Trig_ID_Out