>Hi,
>
>I am writing a code to create a table and DELETE trigger in the SQL Server. I get the error message
>
>"Create Trigger" must be the first statement in a query batch
>
>
>My code (passed to SQL) server does the following (which I basically copied from query window of SSMS):
>1. Create table
>2. Create index
>3. Create Trigger
>
>The code works when executed in SSMS but fails when executed from VFP. What do I need to change in the code? TIA
You will need to send each block of code as a separate sqlexec statement. E.g. in your code there may be GO separators. Each of this block should be send as a separate command to SQL Server from the application but using the same connection handle.
If it's not broken, fix it until it is.
My Blog