Yes sorry if I got you confused.

I am talking about executing a batch of sp's from the code behind from a web application.

thanks.

Well I have checked that out

There are is no such overloaded method for Add

3 out of the 4 take the parameter name as a string and

1...

its nice that you asked.

Basically I was trying this first with a function but then found out that I cannot access a linked server from within a function.

So I...

thanks for the help.

This is exactly what I required.