Friday, March 23, 2012

Executing a Stored Proc in SMO

Could anyone show me how to execute a stored procedure using SMO. I can easily see how to created one and drop one but I cannot see how to execute one.

Thanks very much.

Smo does not have any method to Execute a StoredProcedure. You can however use the Database.ExecuteNonQuery method to run the TSQL to execute the stored procedure.

Thanks,

Kuntal

No comments:

Post a Comment