I can't think of any reaon that it wouldn't work. Both SPT and the Query Analyzer work over ODBC.
-Mike
>Hi Mike,
>
>I've a few sproc scripts that I cannot send using SQLEXEC() because they error out. The same scripts work w/o any problem in QA. I didn't have a time or necessity to look into it closer, though.
>
>>Use the SQL Profiler to verify that the command is coming across correctly. There's no reason that you can create a stored procedure in this fashion.
>>
>>-Mike
>>
>>