Which stored procedure will you be running to add a linked server?

sp_addlinkedserver, sp_addlinkedsrvlogin (More...)

Provides information about current Microsoft® SQL ServerT users and processes (More...)

Yes, Stored procedure in sql server can call itself. (More...)

OLE DB Data Source (More...)

When you need to access a different instance. (More...)

Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements. (More...)

The Cache object is stored in memory. (More...)

2100. (More...)

The name of the system table is sysprocesses .

Select * from sysprocesses


Make sure you run this query in master database. (More...)

To deal with such scenario, you can find "ParameterDirection.ReturnValue" in .net
You can use this parameter direction to read the return value of the stored procedure.

Following example can make it more clearer.
In case, you have following or similar type of return statement somewhere in your stored procedure.
Return -999
To read this value, following code works,

Dim result As Integer = 0
Dim retValParam As New SqlClient.SqlParameter("@RETURN_VALUE", SqlDbType.Int)
retValParam.Direction = ParameterDirection.ReturnValue
dbCommand.Parameters.Add(retValParam)
database.ExecuteNonQuery(dbCommand)
result = retValParam.Value ' here the result must contain the returned value. In this case, it will be -999 (More...)