Using SMO for .NET 2.0 how can I determine...
If a stored procedure's parameter is Input only, or input/output?

You can use the IsOutputParameter property of the StoredProcedureParameter
object e.g.

Server svr = new Server();
StoredProcedure p =
svr.Databases["master"].StoredProcedures["sp_dbcmptlevel", "dbo"];

foreach (StoredProcedureParameter sp in p.Parameters)
{
    Console.WriteLine(sp.Name + "," +
                      sp.DataType.ToString() + "," +
                      (sp.IsOutputParameter ? "Input/Output" : "Input"));
}

Show quoteHide quote

Enterprise Mgr - alter table fails
Checkpoint causes need for better IO subsystem?
Exception trying to import data from Excel .
SQL Server 2005: Error 14258...SQL Server Agent is starting
behavior of command in the 'SQL Query Analyzer'