Does anybody knows how to execute an UPDATE statement in TPT. I tried with STREAM Operator, but getting error like User Doen not have Create MACRO Access.
Also tried with TPT UPDATE Operator, but its giving an error as invalid UPDATE statement as it does not depends on producer operator.
Use the DDL Operator. It is meant for statements that do not return answer sets.