How do I access the value of a stored proc return param in c# using executeNonQuery?

I've got a stored proc to insert a record and return the id of the record inserted in an output param.
How do I access this value in my code after the proc is executed?

param = comm.CreateParameter();
param.ParameterName ="@.MemberID";
param.Direction =ParameterDirection.Output;
param.DbType =DbType.Int32;
comm.Parameters.Add(param);

try
{
rowsAffected =GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
rowsAffected = -1;
}

you should simply be able to access the parameters Value property.

param.Value

how can sql server see more memory

Win 2003 Enterprised Edition
Sql Server Per Proc licence
sql server 2000 standard edition
10 GB Ram
Is it possible for my SQL Server 2000 Std to see more than 2GB of memory? If
so, how? If I install two instances of sql server, will that help?
Each instance can use up to 2GB of memory but that does not do you any good
if a db in one instance needs more than 2GB. If you do then you need
Enterprise Edition.
Andrew J. Kelly SQL MVP
"anna" <anna@.discussions.microsoft.com> wrote in message
news:E2DE692E-9CF6-4EEF-A5B1-BAC15A2FD8A2@.microsoft.com...
> Win 2003 Enterprised Edition
> Sql Server Per Proc licence
> sql server 2000 standard edition
> 10 GB Ram
> Is it possible for my SQL Server 2000 Std to see more than 2GB of memory?
> If
> so, how? If I install two instances of sql server, will that help?
>

how can sql server see more memory

Win 2003 Enterprised Edition
Sql Server Per Proc licence
sql server 2000 standard edition
10 GB Ram
Is it possible for my SQL Server 2000 Std to see more than 2GB of memory? If
so, how? If I install two instances of sql server, will that help?Each instance can use up to 2GB of memory but that does not do you any good
if a db in one instance needs more than 2GB. If you do then you need
Enterprise Edition.
Andrew J. Kelly SQL MVP
"anna" <anna@.discussions.microsoft.com> wrote in message
news:E2DE692E-9CF6-4EEF-A5B1-BAC15A2FD8A2@.microsoft.com...
> Win 2003 Enterprised Edition
> Sql Server Per Proc licence
> sql server 2000 standard edition
> 10 GB Ram
> Is it possible for my SQL Server 2000 Std to see more than 2GB of memory?
> If
> so, how? If I install two instances of sql server, will that help?
>

how can sql server see more memory

Win 2003 Enterprised Edition
Sql Server Per Proc licence
sql server 2000 standard edition
10 GB Ram
Is it possible for my SQL Server 2000 Std to see more than 2GB of memory? If
so, how? If I install two instances of sql server, will that help?Each instance can use up to 2GB of memory but that does not do you any good
if a db in one instance needs more than 2GB. If you do then you need
Enterprise Edition.
--
Andrew J. Kelly SQL MVP
"anna" <anna@.discussions.microsoft.com> wrote in message
news:E2DE692E-9CF6-4EEF-A5B1-BAC15A2FD8A2@.microsoft.com...
> Win 2003 Enterprised Edition
> Sql Server Per Proc licence
> sql server 2000 standard edition
> 10 GB Ram
> Is it possible for my SQL Server 2000 Std to see more than 2GB of memory?
> If
> so, how? If I install two instances of sql server, will that help?
>