how to run SQL server stored procedure and where to be specified execution command.

sumathra

Please check the following:

http://databases.about.com/od/sqlser...toredprocs.htm
http://www.4guysfromrolla.com/webtech/111499-1.shtml

Om Prakash

Check out Microsoft support article regarding this @ http://support.microsoft.com/kb/q164485/

Best Regards
Vadivel

MVP ASP/ASP.NET
http://vadivel.thinkingms.com

Create a recordset object , a connection object

if output procedure then use
Set objrs=objcommand.execute(ra,parameters,options)

if no rows expected and only scripts in proc have to run then
objcommand.Execute ra,parameters,options

this has complete info http://www.w3schools.com/ado/met_comm_execute.asp

There are a lot of ways to call stored procedure from ASP. The easiest and depentable way is the following:

strSQL= "Exec Sproc_ViewOrder " & "'" & parameter1 & "'," & parameter2
set rOrder=Server.CreateObject("ADODB.Recordset")
rOrder.Open strSQL, ConnObj, 1, 3

I use this way for all my stored procedure call.

James
Top-Ink.com
www.top-ink.com