[dba-SQLServer] Pass Thru syntax

John Skolits askolits at ot.com
Fri Aug 11 08:09:51 CDT 2006


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








More information about the dba-SQLServer mailing list