C#/SQL Server 2008R2 Stored Procedure error handling

See more:

C#

SQL

fI have an application that calls a stored procedure. The stored procedure is supposed to query an external ODBC database for all available tables and data. There are some known tables that cause an error and I have accounted for them by wraping the execution in a TRY...CATCH block. When I run the stored procedure from SQL Management Studio it will display the errord tables and finish executing. However, when I call it from my C# application it will return a Timeout error when it hits that first error table. Is there a way to force a Stored procedure to continue to execute and not return the error to the C# applicaion?

SQL Code:
- @tableName is derived from searching all available tables in the external ODBC database.

BEGIN TRY
SET @command = ''
SELECT @command = 'SELECT * INTO [' + @tableName + '] FROM EXTERNAL DATABASE.' + @tableName
EXECUTE(@command)
END TRY
BEGIN CATCH
PRINT 'Error processing the table: ' + @tableName
END CATCH

C# Code:

sqlCommand.ExecuteNonQuery();
catch(SqlException sqle)
{
Console.WriteLine(sqle);
}