[dba-SQLServer] Pass Thru syntax

I got it. Turned out to be the connect string was wrong. What a goof!

Thanks Jim and Billy


-----Original Message-----
From: dba-sqlserver-bounces at databaseadvisors.com
[mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jim Moss
Sent: Friday, August 11, 2006 12:09 PM
To: dba-sqlserver at databaseadvisors.com
Subject: Re: [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
>
>


_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com