Billy Pang
tuxedoman888 at gmail.com
Fri Aug 11 11:17:23 CDT 2006
exec usp_hello @test='my value' the above works for me. are you getting an error message? On 8/11/06, John Skolits <askolits at ot.com> wrote: > > 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 > > -- Billy Pang http://dbnotes.blogspot.com/ "Once the game is over, the King and the pawn go back in the same box." - Italian proverb