Viewing 2 posts - 1 through 2 (of 2 total)
DTS is also a possibility...
August 17, 2007 at 4:28 am
#727583
Hi,
It doesn't like concatenating strings to execute a command. You're better off putting the whole line into a string:
DECLARE
@spID NVARCHAR (10),
@CommandString NVARCHAR(255)
SET @spID = '1'
SET @CommandString = 'DROP TABLE...
August 17, 2007 at 4:24 am
#727582