[dba-SQLServer] Pass Thru syntax

John,

I use the EXEC SP_loadData format and it works just fine. Just make sure
that you are using a SQL Specific Pass-Through query and that you have
your ODBC and other properties set.


> Haven't done this in a while.
>
> I have a pass thru query and need to know the syntax for running a stored
> procedure on SQLServer.
>
>
> If the SP  is called SP_LoadData.
>
> I have Tried :
>
> EXEC SP_loadData
> Exec [dbo].[SP_LoadData}
> EXEC [databasename].[dbo].[Sp_LoadData]
>
> ...
>
> and many others.
>
> Thanks,
>
> John
>
>
>
>
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>